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 ...
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")
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")
  • kazwen's avatar
    kazwen
    Copper Contributor
    Aug 10, 2022

    Icassatti  That's great thank you.  It worked 🙂

Resources