Excel Tip :Sum Multiple Worksheets. #exceltricks #spreadsheetmagic #exceltips

Name: Excel Tip :Sum Multiple Worksheets. #exceltricks #spreadsheetmagic #exceltips | Open Video
Uploaded: 2025-06-22T14:26:43+00:00
Duration: 1 min 33 s

0:00
today I'm going to show you a really
0:02
quick way to sum or the total values of
0:05
all of your worksheets onto a summary
0:07
sheet in your Excel workbook now this is
0:09
a common way that a lot of people track
0:10
their weekly sales monthly sales or even
0:13
daily sales sometimes and and you want
0:16
to have your summary of all of your
0:20
worksheets and in this case all of the
0:23
values are in C2 for each week so you're
0:27
probably used to doing this which will
0:29
be sum and you go to week one you select
0:32
that you may then go to week two and
0:36
select that and so on and so forth now
0:38
that
0:39
works and we've got week one two and
0:43
three in there now this becomes a little
0:44
bit unwieldy if you've got monthly
0:46
especially if you've got weekly so a
0:48
really fast way of doing it is again we
0:51
just still use the sum function
0:54
go to your first
0:56
value select the cell hold down the
0:59
shift key go to week seven or whichever
1:02
week is the last one in your book and
1:05
then close the parenthesis and hit okay
1:07
and that will total up every single week
1:10
in your Excel worksheet so let's just
1:12
have a quick look at the formula and
1:14
it's saying sum week 1 to week seven and
1:18
the cell value is in C2 they're
1:21
obviously all set up the same way and
1:23
all of the values as I said are in C2 so
1:26
that's it

Excel Tip :Sum Multiple Worksheets. #exceltricks #spreadsheetmagic #exceltips

howtoexcelatexcel.com

Speed Up Excel: Set Your Preferred Chart Type

How to Copy & Paste Entire Worksheet. Keep Formulas And Settings.

How To Import Excel Data Into Google Maps. Create Your Own Map!

Clean With Me and Declutter: Relaxing Cleaning Motivation to Start The Week Off Right!

Whole House Deep Clean With Me and Get It All Done Part Two: Cleaning Motivation and Nesting

Whole House Declutter and Organize With Me: Part Two

How to Enable Android Phone Notifications on HUAWEI Watch GT 4

How to Create a Juice Can Mockup in Canva

He Tried to Kick Me Out for His Girlfriend... But I Owned Everything | Sleeping Reddit Pills

Master These Excel Column Resizing Tricks Most Users Don't Know #excel #shorts

Delete All Excel Shapes Instantly With Just One Click!

Can I Say A Random Fact About Every Country?

Up next in 10

Excel Tip :Sum Multiple Worksheets. #exceltricks #spreadsheetmagic #exceltips

howtoexcelatexcel.com