Forum Discussion
Ashar2200
Dec 25, 2022Copper 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
- Subodh_Tiwari_sktneerSilver Contributor
- Ashar2200Copper ContributorThank you so much 🙂
- Subodh_Tiwari_sktneerSilver ContributorYou're welcome!