Forum Discussion

kazwen's avatar
kazwen
Copper Contributor
Aug 09, 2022
Solved

Formula for comparing values and counting if true

Hi all,

 

I have a spreadsheet with two tabs.  on the first tab i have information which includes a column called source.  In this column there are entries like HP/MP/Washington etc - it is a name of an individual or a company there are about 5 in all.  In another column I have a month - April May June etc

 

On my second tab I want to count the number of cases allocated to HP in April, number to MP in May etc.   I am struggling to get a formula which works and am not sure if I should be using COUNTIF or something else.

 

All suggestions welcome thank you

BI & Data Analysis
Formulas and Functions
  • Icassatti's avatar
    Icassatti
    Aug 09, 2022

    Try to use COUNTIFS function.
    like this:

    =COUNTIFS([Source],Sheet2!A1,[Month],Sheet2!B1)

=COUNTIFS([Source],"MP",[Month],"May")

2 Replies

  • Icassatti's avatar
    Icassatti
    Brass Contributor
    Aug 09, 2022

    Try to use COUNTIFS function.
    like this:

    =COUNTIFS([Source],Sheet2!A1,[Month],Sheet2!B1)

=COUNTIFS([Source],"MP",[Month],"May")

Resources