Count to multiple variable in row using Count if

[bluegirl_1962]

I have several variables I need to count in one row. Can this be done? I used the Countif function but am only counting row variable.

 

[Scorpion Steve]

Example?
Steve

 

[bluegirl_1962]

Was able to figure it out... Thanks! used a sum(countif.range.criteria1), (countif.range.criteria2) etc statement

 

[Aladin Akyurek]

Was able to figure it out... Thanks! used a sum(countif.range.criteria1), (countif.range.criteria2) etc statement

Maybe a bit easier on you...

=SUM(COUNTIF(DataRange,{"A","B"}))

=SUMPRODUCT(DataRange,CriteriaRange)

where CriteriaRange is a range, say, X2:X3, housing A and B.

 

[T. Valko]

I have several variables I need to count in one row. Can this be done? I used the Countif function but am only counting row variable.

Try this...

Use cells to hold the variables to be counted.

Book1
	A	B	C	D	E	F	G	H
1	brown	orange	yellow	black	orange	black	green	blue
2	_	_	_	_	_	_	_	_
3	Criteria	Count	_	_	_	_	_	_
4	yellow	4	_	_	_	_	_	_
5	green	_	_	_	_	_	_	_
6	orange	_	_	_	_	_	_	_
Sheet1

This formula entered in B4:

=SUMPRODUCT(--(ISNUMBER(MATCH(A1:H1,A4:A6,0))))

 

[Aladin Akyurek]

Maybe a bit easier on you...

=SUM(COUNTIF(DataRange,{"A","B"}))

=SUMPRODUCT(DataRange,CriteriaRange)

where CriteriaRange is a range, say, X2:X3, housing A and B.

The latter should have been:

=SUMPRODUCT(COUNTIF(DataRange,CriteriaRange))

or, equivalently...

=SUMPRODUCT(ISNUMBER(MATCH(DataRange,CriteriaRange,0))+0)