View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Allewyn
 
Posts: n/a
Default How do I add totals up from different sheets? A running total.

It will look something like this, when using separate sheets

=SUM(List!R1+Priors!S1+'Builders A & B'!Q1+'Builders C & D'!B2+'Builders E &
F'!O1+'Builders G & H'!P2+'Builders I & J'!P1+'Builders K &
L'!P1+Wealthy!W1+'SmBus -
97537'!Q2+SmBus97501!T2+Downtown!M1+DNC!C1+Later!M 1+'List 2'!Q1)
This gives totals from 15 different sheets on a separate summary sheet I'm
using.

"Shawn" wrote:

How do I add totals up from different sheets? A running total of all the
totals on each worksheet?
thanks.