I have a column A with values ( 1,2,3,4,5,6,7,8,9 ) and column B with dates .

I need to have an output of how many values ( 8 ) I had yesterday by date in column A.

My formula for now is =COUNTIFS($A$2:$P$5000,"=" & TODAY(),$B$2:$B$5000,"=" & "8")

But something is not working and I can't get it to work ...

CodePudding user response：

Countif Range should be column Range only not entire table.

If you are using Today(), your extract will not have today's date, you will need to look at Today()-1. Try this: =COUNTIFS($A$2:$A$5000,TODAY()-1,$B$2:$B$5000,8)

CodePudding user response：

Yes, since the Dates are in Column B. Condition criteria should be reversed. =COUNTIFS($B$2:$B$5000,TODAY()-1,$A$2:$A$5000,8)