Formulars
 

I there a formula to be able to take the total for 12 different worksheets
and put them on a different worksheet?

Tks,

Jeff

Hi Jeff

yes, you can use the SUM function if you want to sum a cell in the different
worksheets
assuming that your sheets are called JAN through DEC and you want to add
cell A1 on each sheet the formula on the summary sheet would be
=SUM(JAN:DEC!A1)
this will total cell A1 on all sheets between Jan & Dec inclusive.

if you're talking about more than one cell or where there is similar but not
exactly the same data you might want to look at the consolidation under the
data menu, or pivot tables from multiple consolidation ranges. If you'ld
like more information on either of these please post back

Cheers
JulieD



"med211" wrote in message
...
I there a formula to be able to take the total for 12 different worksheets
and put them on a different worksheet?

Tks,

Jeff