kinkyparamour: Adding cells in multiple worksheets

[KarenAter]

How about if I send you my workbook to look at? I'm not sure how to explain what I am doing wrong. Thanks for your help.

Karen

 

[daleyman]

email to me if you like, david@monnetqos.com

 

[kinkyparamour]

Karen,

If Dave has not been able to help please feel free to send me your file. I will be happy to look at it for you............

Kinkyparamour@AOL.com

 

[kinkyparamour]

Karen,

Did the changes made to your spreadsheet work for you?


Denny

 

[daleyman]

reviewed the worksheet, user wants to add cells from separate worksheets adding zero value where null.

i suggested the following but thought somebody might be able to suggest more succinct formula...

=if(isnumber('sheet1'!a1),'sheet1'!a1,0)+if(isnumber('sheet2!a2),'sheet2'!a2,0)+...etc

 

[kinkyparamour]

I added the following to her worksheet and it worked great.

=SUM('03-12'!$F$24,'03-22'!$F$24,'03-31 CG'!$E$24,'03-31 PC'!$E$24)

I also made a couple of other changes to the workbook for her while i was in there. She E-mailed me today saying she was very happy with the help you and I supplied.

Denny