Use named ranges in array formula
The month name is text.
"Pete_UK" wrote:
Does the range RMO actually contain month names, or are these dates?
Pete
On Feb 26, 7:13 pm, Jan wrote:
I still get the #N/A error when entered as array. I have triple checked my
named ranges and the respective columns are as described.
Any other suggestions.
Thank you.
"Pete_UK" wrote:
Sorry, I forgot about the named ranges. Try this:
=D8+SUM(IF((RBU="NE-777-IUC")*(RMO="MÂ*arch"),RLeas,0))
Again, entered using CSE.
Hope this helps.
Pete
On Feb 26, 6:59 pm, "Pete_UK" wrote:
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")*Repl acements!$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 -- Hide quoted text -
- Show quoted text -- Hide quoted text -
- Show quoted text -
|