Forum Discussion
Excel - COUNTIF Function
Furthermore, in addition to how Detlef corrected your formula, from your description I don't think that is even what you want/need. It sounds like you will have some sort of readings that will start at 150 and go down as the Chlorine is used so you don't want COUNT (that will just tell you how many readings were taken) but you want something like 150-MIN to find the consumption so maybe something like this:
=150 - MINIFS(H3:H20, B3:B20, "N. Well")
Alternatively if the values you have recorded in column H are USAGE values then you want SUMIF so either:
=150 - SUMIF(B3:B20, "N. Well", H3:H20)
or
=150 - SUMIFS(H3:H20, B3:B20, "N. Well")
the difference is the second option (sumifS) gives you the option to have additional conditionals
*
Am I misunderstanding how the formula works or am I using the wrong formula all together?
Yes, you are..
countifs(b3:b20,"N. Well",h3:h20,"<=150")
Furthermore, in addition to how Detlef corrected your formula, from your description I don't think that is even what you want/need. It sounds like you will have some sort of readings that will start at 150 and go down as the Chlorine is used so you don't want COUNT (that will just tell you how many readings were taken) but you want something like 150-MIN to find the consumption so maybe something like this:
=150 - MINIFS(H3:H20, B3:B20, "N. Well")
Alternatively if the values you have recorded in column H are USAGE values then you want SUMIF so either:
=150 - SUMIF(B3:B20, "N. Well", H3:H20)
or
=150 - SUMIFS(H3:H20, B3:B20, "N. Well")
the difference is the second option (sumifS) gives you the option to have additional conditionals