Forum Discussion

Copper Contributor

Apr 17, 2026

Excel - COUNTIF Function

Happy Friday! I am trying to use the COUNTIF Function on a worksheet that tracks how much liquid chlorine is used at 3 different water wells each month, each well having 2 chlorine cylinders. I'm not...

excel

Formulas and Functions

office 365

Detlef_Lewin

Silver Contributor

Apr 20, 2026

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")

m_tarler
Silver Contributor
Apr 21, 2026
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