Posted to microsoft.public.excel.worksheet.functions
|
|
Function argument not returning a value
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
---
|