Function argument not returning a value
Thanks so much!
Linda
"RagDyer" wrote:
Your formula is an *array* formula.
--
Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead of
the regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually. Also, you must use CSE when
revising the formula.
However, you could convert it to the Sumproduct() function, and then use a
simple <Enter:
=Sumproduct((Master!$A$6:$A$504="January")*(Master !$C$6:$C$504="LBK")*Master!$H$6:$H$504)
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Linda" wrote in message
...
=SUM((Master!$A$6:$A$504="January")*(Master!$C$6:$ C$504="LBK")*Master!$H$6:$H$504)
"FSt1" wrote:
hi
post your formula please.
Regards
FSt1
"Linda" wrote:
Hi All,
Quick question: I'm using the SUM fx in order to create a formula that
would
return a value based on information in a different worksheet within the
same
workbook. When I key in the formula and hit ENTER, I get a 0 in the
cell of
interest. However, when I click on the fx button at the top, it shows
my
formula and my formula result as 20.75. Anyone know why the cell won't
show
20.75 if the fx argument is calculating correct?
Thanks a million,
Linda
|