Excel Formula Help

[Closed]
Report
-
 Trowa -
Hello,

I have two columns - one can have 1 or blank (so I can SUM the 1s). The other has an H or A .

I need a formula that will look in each column to see if there is a 1 and an H and I want the count of how many times this happens.

I figured out how to COUNTIF there were an x's in the column, but not sure how to have them look at two different columns to count them.

Clear as mud, right?

1 reply

Hi airolgmd,

So your sheets look a bit like this:

1	h
1	h
1	a
	a
	h
	a
1	h
1	h
	h
1	a
1	a


In this case there are 4 rows containing both a 1 and a h. Use the following formula to get this result:
=SUM((A1:A11=1)*(B1:B11="h"))
This is an array formula, so confirm by hitting Ctrl+Shift+Enter.

As clear as a rainy day, right?

Best regards,
Trowa