Excel formula

Closed
yh - May 29, 2009 at 02:14 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jun 1, 2009 at 02:07 AM
Hello,
i want to count some cell but if 2 conditions are meet.

2 responses

Orkt Posts 6 Registration date Friday May 29, 2009 Status Member Last seen June 22, 2009 1
May 31, 2009 at 07:48 PM
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
Check out that link, there are some "sum" and Multiple Condition Tests. I dont quite understand what you are looking for.
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 166
Jun 1, 2009 at 02:07 AM
Suppose you have data in Column A & B

A B
a 1
a 2
b 3
a 1
b 1

Now you want to count "a" against the value of "1" in column B

Array formula

=SUM((A1:A5="a")*(B1:B5=1)). after writing this formula Press Ctrl+Shift+Enter (array formula)

second method

=SUMPRODUCT(--(A1:A5="a"),--(B1:B5=1))