"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
---