Previous Topic Next Topic

Excel Formula Help

Closed
airolgmd - Jan 10, 2010 at 04:19 PM
 Trowa - Jan 11, 2010 at 09:08 AM
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

Answer 1 / 1
Trowa
Jan 11, 2010 at 09:08 AM
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
0