Last answered:

22 Aug 2022

Posted on:

02 Jun 2022

3

Confused by using quotation marks for <= and >= and using & in countifs function

As far as I remember we used quotation marks and & for text data, how are they being used here for comparison between data points? What's wrong with the following code?
=COUNTIFS($B$13:$B$32,>=$E15,$B$13:$B$32,<=$F15)

I really appreciate it if you help me out!

2 answers ( 0 marked as helpful)
Posted on:

10 Jul 2022

0

Would like an answer to this as well!

Posted on:

22 Aug 2022

0

Yes, answer please?!

Submit an answer