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.

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,686 questions
0 comments No comments
{count} votes

Accepted answer
  1. Emi Zhang-MSFT 23,586 Reputation points Microsoft Vendor
    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
  1. Oskar Shon 866 Reputation points MVP
    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 No comments