I have a spreadsheet with three columns of data. The first column is
labeled "Male", the second is labeled "Female" and the third is "Age".
Each row in the sheet corresponds to a caller. So if the caller was a
female, we marked a '1' under female and then under 'Age' put the
numeric age of the caller. What I am trying to do is determine the age
ranges of the callers.
So what I need is a function that will count/sum or whatever rows
C4:C81 IF the value of the cell is greater than or equal to 30 AND less
than 40.
It seems COUNTIF can't except multiple ranges and in doing SUMIFs, my
answer is always '1' or '0'. It seems to be summing each cell, not the
range. Please help!
Thanks!
--
croakingtoad
------------------------------------------------------------------------
croakingtoad's Profile:
http://www.excelforum.com/member.php...o&userid=29152
View this thread:
http://www.excelforum.com/showthread...hreadid=488728