Forum Discussion

samhatchernz's avatar
samhatchernz
Copper Contributor
Dec 21, 2021

conditional count function

team

 

I am Trying to build a formula that counts the amount of times a TODAY() appears, on the condition that another cell on its row displays a certain text

 

IE

 

In cell J1 i want to have a total count if Cell I5: = TODAY() and Cell M5 = "MOVE TO ALT DATE"

i want to be able to have this calculation roll down the sheet

 

any ideas

Formulas and Functions

1 Reply

  • Martin_Weiss's avatar
    Martin_Weiss
    Bronze Contributor
    Dec 21, 2021

    Hi samhatchernz 

     

    you can use the COUNTIFS function to do this:

    =COUNTIFS(I5:I19;TODAY();M5:M19;"MOVE TO ALT DATE")

     

    You just need to adjust the ranges, so they fit your needs. Just note, that both ranges (in my example I5:I19 and M5:M19) need to have the same size. In other words, they need to cover the same number of lines, otherwise it will not work.

Resources