Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-26-2012, 01:34 AM
lucnijs lucnijs is offline count how many tims a certain value occurs Mac OS X count how many tims a certain value occurs Office 2008 for Mac
Novice
count how many tims a certain value occurs
 
Join Date: Mar 2012
Posts: 3
lucnijs is on a distinguished road
Default count how many tims a certain value occurs

Hi!

I have a spreadsheet for the amount of times students practised their instrument and for the help they get from their parents

so I have 2 columns per day, one for the amount of time practised and one to indicate if and by whom they were helped.
e.g.
F = Monday_practiceTime
G = Monday_helpedBy


H = Tuesday-practiceTime
I = Tuesday_helpedBy
J = Wednesday_practiceTime
K = Wednesday_helpedBy
...

I now want to see how many days they practised a week.
See I was thinking to count the cells with a number greater than 0.
I used COUNTIF:

COUNTIF(F2+H2+J2+L2+N2+P2+R2, ">0")

But I get an error message saying that the range is invalid.

How can I do this right?
I use Excel for mac 2008

Thank you!

Luc
Reply With Quote
 

Tags
countif



Similar Threads
Thread Thread Starter Forum Replies Last Post
Use of MIN and count function together khokababu Excel 0 02-22-2012 09:40 AM
Count If Formula beb1227 Excel 10 06-19-2011 11:19 AM
count how many tims a certain value occurs Count By Color beb1227 Excel 4 06-15-2011 08:46 AM
count how many tims a certain value occurs Count in Excel zanat0s Excel 3 06-09-2011 10:53 AM
How to Count from Different Cells? Shahzad Excel 3 06-26-2010 01:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:04 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft