I am not sure that this will work as you need to define the range for
SUMPRODUCT
Each element needs to be the same size
=SUMPRODUCT(--(A1:A10="Feb"),--(B1:B10="John"),C1:C10)
edvwvw
Lars-Åke Aspelin wrote:
Hi,
[quoted text clipped - 16 lines]
Thank you,
Try this formula:
=SUMPRODUCT(--(A:A="Feb"),--(B:B="John"),C:C)
Hope this helps / Lars-Åke
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/201004/1