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

The No-Code Way to List All Files Using Power Query Excel Tip

Speed Up Excel: Set Your Preferred Chart Type

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

WoW! 1 Site Crashed, Another Is DEAD.

Standoff 2 in Cubot X19 | Shooter Game

Bag Holder Review

5 High-Protein Breakfast Recipes To Start Your Day Right | Myprotein

Angel Answers Fan Questions w/ No Filter, Reveals New McDonalds Meal + OG Advice From Lisa Leslie

2Hype ZackTTG SURPRISE $20,000 Streaming & Game Room Makeover!

5 Isometric Exercises To Jump Higher And Get Rid Of Knee Pain!

Pro Dunker Reacts To Steph Curry’s Workouts!

6'2 Isaiah Rivera and 6'0 John Evans Dunk Session: Rim Height 9'11.25"

Up next in 10

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

howtoexcelatexcel.com