Forum Discussion

tsbarton70's avatar
tsbarton70
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's avatar
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's avatar
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