Forum Discussion
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...
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.