Count value with multiple Condition

Muhammad Asif 121 Reputation points

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.


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

Accepted answer
  1. Emi Zhang-MSFT 23,031 Reputation points Microsoft Vendor

    Hi @Muhammad Asif ,
    Try this formula:



    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

    Why you asking 3th times the same questions?

    0 comments No comments