adding results from formulas (ignoring #divo)

[J.W. Aldridge]

i feel crazy asking this question (knowing as much as i do)

but i have a formula that adds the values of cells which contains the
results of other formulas when data is inserted. ineed a working sum
regardless of the other cells having a result.

=SUM(E4,H4,K4)

e4=IF(IF(D5=""," ",(D5/E$2)*D$26)>D$26,D$26,IF(D5=""," ",(D5/E$2)*D
$26))
h4=MIN(35,(H$2/(G4))*G$26)
K4==IF(J4="",0,IF(J4=0,J$26,IF(J4=1,J$26,IF(J4>J$26,0, ))))

 

[T. Valko]

Try this:

=SUM(IF(ISNUMBER(E4),E4),IF(ISNUMBER(H4),H4),IF(ISNUMBER(K4),K4))

 

[Bob Phillips]

=SUM(IF((ISNUMBER(E4:K4))*(MOD(COLUMN(E4:K4),3)=2),E4:K4))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)