SUMPRODUCT help

[ddub25]

Trying to achieve the following:

IF MATCH found in $K$51 and column A:A (K51 = "Sep-10" in mmm-yy format)
AND corresponding row in Column B:B = "Alias"
THEN, SUM corresponding row in Column E:E

Any ideas. Thanks.

Dan

 

[T. Valko]

Trying to achieve the following:

IF MATCH found in $K$51 and column A:A (K51 = "Sep-10" in mmm-yy format)
AND corresponding row in Column B:B = "Alias"
THEN, SUM corresponding row in Column E:E

Any ideas. Thanks.

Dan

What version of Excel are you using?

=SUMPRODUCT(--(A2:A10=K51),--(B2:B10="Alias"),E2:E10)

If you're using Excel 2007 or later:

=SUMIFS(E2:E10,A2:A10,K51,B2:B10,"Alias")

The SUMIFS version would be the best choice.

 

[ddub25]

Thanks, SUMIFS worked for me fine.

Dan

 

[T. Valko]

Thanks, SUMIFS worked for me fine.

Dan

You're welcome. Thanks for the feedback!