adding results from formulas (ignoring #divo)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J.W. Aldridge - 12 Nov 2007 17:31 GMT

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, ))))

Reply to this Message

T. Valko - 12 Nov 2007 18:55 GMT

Try this:

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

Signature

Biff
Microsoft Excel MVP

>i feel crazy asking this question (knowing as much as i do)
>
[quoted text clipped - 8 lines]
> 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, ))))

Reply to this Message

Bob Phillips - 12 Nov 2007 19:01 GMT

=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.

Signature

---
HTH

Bob

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

>i feel crazy asking this question (knowing as much as i do)
>
[quoted text clipped - 8 lines]
> 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, ))))

Reply to this Message