Forum Discussion

tsbarton70's avatar
tsbarton70
Copper Contributor
Apr 17, 2026
Solved

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
  • m_tarler's avatar
    m_tarler
    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

tsbarton70's avatar
tsbarton70
Copper Contributor
Apr 27, 2026

Thank you both for the help. It's much appreciated. Maybe one day I will have as much knowledge as you do, but I'm sure it will require classes of some sort. All of my knowledge is self-taught, with the exceptions of coming here a couple of times for things I couldn't figure out lol.