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
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jun 1, 2009 at 02:07 AM
Related:
- Excel formula
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Transfer data from one excel worksheet to another automatically formula - Guide
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
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.
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
165
Jun 1, 2009 at 02:07 AM
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))
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))
