Share via

FORMULA HELP

BI [131] 1 Reputation point
2021-03-30T10:15:39.107+00:00

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

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,725 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erin Ding-MSFT 4,461 Reputation points
    2021-03-31T02:08:13.697+00:00

    Hi @BI [131]

    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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.