sum the results of a group of formulas

I have a spreadsheet with forms (questions with checkbox fields) in it. Each
checkbox cell is linked to a copy of the same group questions where
TRUE/FALSE resposnes are calculated for the forms. Based on the TRUE/FALSE
response I have the following formula =IF(B301=FALSE,"0",IF(B301=TRUE,"10")).
This formula works. I then need to reference the result of that formula to
the original location/set of questions which would be cell E9. I have 18
questions/fields that operate in this same manner with different formula
results. I need to be able to calculate (SUM) the results of all of the
formulas and place the result in field E33.
I've tried copying the formula from E301 to E9, linking E9 to E301
(=$E$301). I just cannot make these SUM. NOTE: All of the cells in row E
that need to SUM are not adjacent.

I found the answer to my own question (after about 5 hours of searching).
If anyone has the same issue - the answer is:
=SUM(E9)+(E10)+(E12)
You can add on as many cells as needed.
ASTJELS

"astjels" wrote:

> I have a spreadsheet with forms (questions with checkbox fields) in it. Each
> checkbox cell is linked to a copy of the same group questions where
> TRUE/FALSE resposnes are calculated for the forms. Based on the TRUE/FALSE
> response I have the following formula =IF(B301=FALSE,"0",IF(B301=TRUE,"10")).
> This formula works. I then need to reference the result of that formula to
> the original location/set of questions which would be cell E9. I have 18
> questions/fields that operate in this same manner with different formula
> results. I need to be able to calculate (SUM) the results of all of the
> formulas and place the result in field E33.
> I've tried copying the formula from E301 to E9, linking E9 to E301
> (=$E$301). I just cannot make these SUM. NOTE: All of the cells in row E
> that need to SUM are not adjacent.

as does

=E9+E10+E12


--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"davesexcel" <[email protected]> wrote
in message news:[email protected]...
>
> This works as well
>
> =SUM(E8,E9,E12)
>
>
> --
> davesexcel
>
>
> ------------------------------------------------------------------------
> davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
> View this thread: http://www.excelforum.com/showthread...hreadid=540876
>