You're welcome!

--
Biff
Microsoft Excel MVP


"Linda" wrote in message
...
Thanks a million!!!

Linda

"T. Valko" wrote:

Or, you could use this non-array version.

Normally entered:

=SUMPRODUCT(--(Master!$A$6:$A$504="January"),--(Master!$C$6:$C$504="LBK"),Master!$H$6:$H$504)

Better to use cells to hold the criteria:

A1 = January
B1 = LBK

=SUMPRODUCT(--(Master!$A$6:$A$504=A1),--(Master!$C$6:$C$504=B1),Master!$H$6:$H$504)


--
Biff
Microsoft Excel MVP


"Max" wrote in message
...
"Linda" wrote:
=SUM((Master!$A$6:$A$504="January")*(Master!$C$6:$ C$504="LBK")*Master!$H$6:$H$504)

It's an array formula. If you array-enter it in the cell, ie press
CTRL+SHIFT+ENTER instead of just pressing ENTER, it'll return the
correct
result. Just click inside the formula bar again, then press
CTRL+SHIFT+ENTER.
If you do it correctly, Excel will wrap curly braces around the
formula:
{ }.
You should see these braces in the formula bar as a visual check that
the
formula is correctly array entered.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---