Count value with multiple Condition

Muhammad Asif 121 Reputation points
2022-11-09T16:18:22.33+00:00

Cell A Cell B Cell C
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 f5 when the date between 01-Nov-2022 to 30-Nov-2022
in this total data value of google is 2.

The picture is attached for a better understanding.

258843-count.jpg

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

Accepted answer
  1. Emi Zhang-MSFT 21,141 Reputation points Microsoft Vendor
    2022-11-10T01:43:57.85+00:00

    Hi @Muhammad Asif ,
    Try this formula:

    =SUMPRODUCT(--($A$4:$A$13>=$A$2),--($A$4:$A$13<=$B$2),--($B$4:$B$13=$D$3),--(C4:C13<>""))  
    

    258954-image.png


    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.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Oskar Shon 866 Reputation points MVP
    2022-11-09T16:45:52.497+00:00

    Why you asking 3th times the same questions?
    count-function.html
    count-formula-with-condition.html

    0 comments No comments