excel vba - if formula almost done but something missing

  • Thread starter Thread starter chief
  • Start date Start date
C

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
 
Hi
how about

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

Cheers
JulieD
 
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"))
 
Hi Frank

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

Cheers
JulieD
 
You could change your formula to: =IF(H15="som
name",SUM(K42:K44)+K46,IF(H15<>"another name",SUM(K42:K46),""))
 
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)
 
Back
Top