SOLVED

Count entries in a column based on date in different column

Copper Contributor

Count entries in a column based on date in different column

Hello everyone,

I am trying to get the number of entries in a column based on date in a different column.

For example, I have the date in Column A and entries in column B. I want to get the total number of entries in column B for yesterday or today. The entries are in text format. I have tried and failed with Countif, sumproduct etc. I am trying something like this  - =Countif(B:B,A:A=Today()) but I am getting errors. Can someone help me with right formula. Please help me and thank you in advance.

3 Replies
best response confirmed by Ashar2200 (Copper Contributor)
Solution

Re: Count entries in a column based on date in different column

You may try something like this...

``=COUNTIFS(A:A,TODAY(),B:B,"<>")``

Re: Count entries in a column based on date in different column

Thank you so much :)

Re: Count entries in a column based on date in different column

You're welcome!
1 best response

Accepted Solutions
best response confirmed by Ashar2200 (Copper Contributor)
Solution

Re: Count entries in a column based on date in different column

You may try something like this...

``=COUNTIFS(A:A,TODAY(),B:B,"<>")``