Forum Discussion
Using SUMIF with Greater/less than times
Hi there,
I have a spreadsheet that calculates a time. I want to automate a count of how many are >3:00 and <3:00.
I use =SUMIF(M2:M110,"<3:00")
But instead of getting an answer with a whole number, I'm getting a strange percentage .21 ? (The column format is set to general, I changed it to number and it didn't make a difference).
Likewise, when I run it for >3:00; I get 3.12 ...
What am I doing wrong?
Thanks
Sarah
=COUNTIF(M2:M110,"<3:00")
If you want to COUNT how many are >3:00 and <3:00 then i'd suggest applying COUNTIF.
=COUNTIF(M2:M110,"<3:00")
If you want to COUNT how many are >3:00 and <3:00 then i'd suggest applying COUNTIF.
OliverScheurich Thank you! That worked!
