Forum Discussion
Solved
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 ...
=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!
