Hi, i have a formula here that doesn't work
=SUM(IF((TB!$B$2:$B$4133=$A2)*(TB!$D$2:$D$4133="M" ),TB!$I$2:$I$4133))

What i was after is to get the total in the other spreadsheet under a
particular department and code but all i get under this formula is 0 and i
don't know why. Please help, thanks.

Teresa

This is an array formula, which means that it should be committed
using CTRL-SHIFT-ENTER (CSE) at the same time, rather than just the
normal ENTER. Double-click on the cell as if to edit it, then do CSE.
If you do this correctly, then Excel will wrap curly braces { } around
the formula when viewed in the formula bar - you must not type these
yourself.

Hope this helps.

Pete

On Nov 7, 12:06 am, teresa wrote:
Hi, i have a formula here that doesn't work
=SUM(IF((TB!$B$2:$B$4133=$A2)*(TB!$D$2:$D$4133="M" ),TB!$I$2:$I$4133))

What i was after is to get the total in the other spreadsheet under a
particular department and code but all i get under this formula is 0 and i
don't know why. Please help, thanks.

Teresa