Share via

Count function

Muhammad Asif 121 Reputation points
2022-11-08T11:54:03.71+00:00

Cell A Cell B Cell C Cell D
01-Nov-2022 Google 1
05-Nov-2022 Facebook 1
10-Nov-2022 Yahoo 1
31-Nov-2022 Google 1
01-Dec-2022 Google 1
I want to count the value of google in cell D when the date between 01-Nov-2022 to 31-Nov-2022
in this total data value of google is 2.

Microsoft 365 and Office Excel For business Windows
0 comments
Accepted answer
  1. Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff
    2022-11-09T03:15:45.61+00:00

    Hi @Muhammad Asif ,
    You can try to create a start date and end date, then enter the formula: 

    =SUMPRODUCT(--($A$1:$A$5>=$H$1),--($A$1:$A$5<=$H$2),--($B$1:$B$5=B1))

    258410-image.png

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

    If the response 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.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oskar Shon 866 Reputation points
    2022-11-08T17:53:23.27+00:00

    Date is a number, so date+1 should giving you next date.
    That is a first case.

    After that you can use formula =COUNTIFS()

    Regards.

    0 comments

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.