M
med211
I there a formula to be able to take the total for 12 different worksheets
and put them on a different worksheet?
Tks,
Jeff
and put them on a different worksheet?
Tks,
Jeff
J
JulieD
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
EC!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
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
EC!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