question

BI131-8593 avatar image
0 Votes"
BI131-8593 asked erinding-msft commented

FORMULA HELP

Good day!

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.82705-formula.png


office-excel-itpro
formula.png (4.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

erinding-msft avatar image
0 Votes"
erinding-msft answered erinding-msft commented

Hi @BI131-8593

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.
82996-image.png

Then drag the lower right corner of the cell to quickly apply the formula to other cells.
82969-image.png

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.


image.png (49.2 KiB)
image.png (6.8 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @BI131-8593
How is your issue going now?
Any updates, please let me know.

0 Votes 0 ·