I need to count "Advertisement" on my database for the month of January, February, March.
What formula should i use?
Thank you so much in advance.
Could you please give a sample of your database?
Generally, we could use COUNTIF function to count the number of cells that meet a criterion.
I did a simple test, here I use formula =COUNTIF(A:A,E2) in cell F2, =COUNTIF(B:B,E2) in G2 and =COUNTIF(C:C,E2) in H2.
Then drag the lower right corner of the cell to quickly apply the formula to other cells.
If you have any questions, please provide a simple sample which may help troubleshoot your issue better.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
5 people are following this question.