Check multiple column sizes for criteria?

[kes0_]

Hello, I have 3 columns of data and I'd like to count a criteria that appears in the first column AND a second criteria that can appear in either of the last 2 columns. However COUNTIFS does not take ranges of different sizes, and I can't get SUMPRODUCT to work because I need to use Wildcards since some of the data values varies but would still count for my criteria. What can I do?

 

[kes0_]

I have tried =SUM(--(FILTER(D5:E999, C5:C999="Undergrad")="Letters*")) . How can I change this so that it would work? Thanks!

 

[jtakw]

Hi,

Can your criteria (Letters*) appear in Both column D and E on the same row?

Edit: If so, does it Count as 1 or 2?

 

[kes0_]

No, it can only appear in one of them. Thanks!

 

[jtakw]

Thanks for the info.

If I understand correctly...
I don't have the FILTER function, but this SUM/COUNTIFS and SUMPRODUCT should work:

Change/adjust Cell Range/references to suit your data:

Book3.xlsx
	B	C	D	E
1
2
3	3	Undergrad		Lettershead
4	3	Undergrad
5		Undergrad	Lettershirt
6		Undergrad
7		Under	Letters
8		Under		Letters
9		Undergrad		Letters
10
Sheet888

Cell Formulas
Range	Formula
B3	B3	=SUM(COUNTIFS(C1:C10,"Undergrad",D1:D10,"Letters*"),COUNTIFS(C1:C10,"Undergrad",E1:E10,"Letters*"))
B4	B4	=SUMPRODUCT((C1:C10="Undergrad")*(ISNUMBER(SEARCH("Letters",D1:E10))))