excel vba - if formula almost done but something missing

[chief]

I have this formula in cell K47, but it comes up as #VALUE, what i
missing

=IF(H15="some name",SUM(K42:K44)+K46),IF(H15<>"anothe
name",SUM(K42:KK46))

any idea

 

[JulieD]

Hi
how about

=IF(H15="some name",SUM(K42:K44,K46),IF(H15<>"another name",SUM(K42:K46),"")

Cheers
JulieD

 

[Frank Kabel]

Hi
what value is in K46?. You may try:
=IF(H15="some name",SUM(K42:K44,K46),IF(H15<>"another
name",SUM(K42:KK46),"not defined"))

 

[JulieD]

Hi Frank

there's a reference to KK46 in the last SUM range which needs to be
"adjusted" also

Cheers
JulieD

 

[ElsiePOA]

You could change your formula to: =IF(H15="som
name",SUM(K42:K44)+K46,IF(H15<>"another name",SUM(K42:K46),""))

 

[Frank Kabel]

Hi Julie
good catch

 

[Alan]

If you only need 'some name' as the citeria
=IF(H15="some name",SUM(K42:K44)+K46,SUM(K42:K46))
otherwise use nested IF's like
=IF(H15="some name",SUM(K42:K44)+K46,IF(H15="Someothername",SUM(K42:K46),0))
up to a max of seven,
Regards,
I'm assuming that SUM(K42:KK46) should be SUM(K42:K46)