Try this as an array* formula:

=D8+SUM(IF((Replacements!$C$3:$C$15="NE-777-IUC")*(Replacements!$K$3:$K
$15="M*arch"),Replacements!$N$3:$N$15,0))

I presume you want to add to D8 all the values from N3:N15 where
C3:C15="NE-777-IUC" and K3:K15="March".

* as this is an array formula, you must use CTRL-SHIFT-ENTER to commit
the formula, rather than just ENTER.

Hope this helps.

Pete

On Feb 26, 6:43 pm, Jan wrote:
When I enter the formula you show, I only get the #Value error. If I enter
the formula as an array: ctrl, shift, enter, I get the #N/A error.

Any other suggestions?



"Toppers" wrote:
Try:

=D8+SUM((RBU="NE-777-IUC")*(RMO="March")*Rleas)

"Jan" wrote:

I am trying to use named ranges in an array formula and it won't work.. Below
is the current array formula as entered in cell E8.

{=D8+SUM((Replacements!$C$3:$C$15="NE-777-IUC")*(Replacements!$K$3:$K$15="M*arch")*Replaceme nts!$N$3:$N$15)}

Following are the named ranges from another worksheet withing the same
workbook.
Name range for Column $C$3:$C15 = RBU
Name range for column $K$3:$K$15=RMO
Name range for Column $N$3:$K$15=RLeas

How would I rewrite the array formula to use only the named ranges? Any
help will be greatly appreciated.

TIA
Jan- Hide quoted text -

- Show quoted text -