Thread
:
SUMPRODUCT Works Sometimes Why
View Single Post
#
2
Don Guillett
Posts: n/a
it does not work.
Means???
--
Don Guillett
SalesAid Software
"Mestrella31" wrote in message
...
I have use this formula before, but i try it again on another sheet and
now
it does not work.
This Works:
=SUMPRODUCT(('Dec Actual'!$F$2:$F$100="0103")*('Dec
Actual'!$G$2:$G$100=B101)*('Dec Actual'!$I$2:$I$100))
This does not:
=SUMPRODUCT(('Source'!A5:A350="A")*(Source'!B5:B35 0=A8)*('Source'!AM5:AM350)
)
Reply With Quote