Simple CountIf

Topic

New Reply

I’m having a syntax nightmare:

=COUNTIF(‘History’!$BR$2:$BR$172,50)
=COUNTIF(‘History’!$BR$2:$BR$172,49.5)
=COUNTIF(‘History’!$BR$2:$BR$172,49)
=COUNTIF(‘History’!$BR$2:$BR$172,?) – Want =45
=COUNTIF(‘History’!$BR$2:$BR$172,?) – Want <45

Reply | Quote

Replies

Want =45:

=COUNTIF(‘History’!$BR$2:$BR$172,”<49")-COUNTIF('History'!$BR$2:$BR$172,"<45")

or

=SUMPRODUCT(('History'!$BR$2:$BR$172=45))

Want <45:

=COUNTIF('History'!$BR$2:$BR$172,"<45")

Reply | Quote

Thanks,

I should write a book:

“How to waste valuable moments of your life missing silly little things like “””

Reply | Quote