Formula for comparing values and counting if true

[kazwen]

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

[#2 · Accepted solution]

Try to use COUNTIFS function.
like this:

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

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

[#3]

@Icassatti  That's great thank you.  It worked :)