Excel formula [Closed]

Report
-
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
Hello,
i want to count some cell but if 2 conditions are meet.

2 replies

Posts
6
Registration date
Friday May 29, 2009
Status
Member
Last seen
June 22, 2009
1
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.
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
215
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))

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!