sumproduct with multiple variables
That doesn't meet the criteria:
It is essential that A is matched with B and
that C is matched with D.
--
Biff
Microsoft Excel MVP
"Jacob Skaria" wrote in message
...
Try the below
=SUMPRODUCT(ISNUMBER(MATCH(A1:A6,{"A","C"},0))*
ISNUMBER(MATCH(B1:B6,{"B","D"},0)),C1:C6)
If this post helps click Yes
---------------
Jacob Skaria
"sam" wrote:
hi everyone,
here is my issue. i am using SUMPRODUCT for a couple of criteria and
returning the sum of another column. E.g.
A B 1
A C 2
B C 3
B E 4
C A 5
C D 5
=SUMPRODUCT((A1:A6="A")*(B1:B6="B"),C1:C6)+SUMPROD UCT((A1:A6="C")*(B1:B6="D"),C1:C6)
= 1 + 5
= 6
This all works fine but I was wondering if there was another option so i
would not have to use SUMPRODUCT multiple times. It is essential that A
is
matched with B and that C is matched with D.
Thanks
Sam
|