I am getting an error message.

=COUNTIFS(Sheet1!B2:B33, "Serial Examples", Sheet2!B2:B35, "Logos")

I am wanting to get a total of the number of occurences when these two criteria are met.

I don't know what I am doing wrong. Please offer a suggestion.

CodePudding user response：

Ranges Sheet1!B2:B33 and Sheet2!B2:B35 are not the same size