adding results from formulas (ignoring #divo)

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

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, ))))
 
=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)
 
Back
Top