Multiple Worksheets

[Meayen]

Hello Everyone!

Could anyone please tell me how i can do this or if its possible

i have 4 worksheets in a workbook and i need to get totals from each sheet to the last worksheet

for instance:'

Sheet 1 B82
Sheet 2 B106
Sheet 3 B106
Sheet 4 B114
then B120 in sheet 4 would have those totals from all 4 sheets

tried several things but keep getting a #value error

Next thing is if I =yes/no then the answer in column J would be Bold and Red is there anyway to do this

Please help

Thanks in advance

Meayen

 

[squishykid]

Multi-sheet formula

this formula in the cell on sheet 4 should work.

=Sheet1!B82+Sheet2!B106+Sheet3!B106

Note that if you have changed the sheet name(s), then the formula will have to be modified...ie

=FirstSheetName!B82+AnotherSheet!B106...etc

You should ba able to do this simply by starting with an equal sign and then clicking between pages and cells to fill in the formula, using the + sign between selections. If you are still having problems, then a possible problem is the that cells you are attempting to add contain something other than numerical data.

As far as changing the color of a cell or font from a formula, I am not aware, but it might be possible.


Shane

 

[Meayen]

Thanks for the reply shane

i actually figured out the page thing im still stuck on the cell color.

if b13 = no then c1 = red but imworking on it still thanks for your feedback

Meayen