Sum of Sales by Time & Weekdays in Excel 2010 functions | ExcelGuru
Learn how to calculate the sum of sales for specific times and weekdays using Power Query in Excel 2010.
In this step-by-step tutorial, you’ll see how to transform your data, filter by time, select weekdays, and quickly get your total sales.
Perfect for data analysts, Excel learners, and anyone who works with sales reports.
What you’ll learn:
Load data into Power Query in Excel 2010
Filter by particular time (e.g., after 12 PM)
Select specific weekdays (e.g., Tuesday & Thursday)
Group and sum sales efficiently
Export the result back to Excel
📌 No complex formulas – only Power Query!
…
Watch on YouTube ↗
(saves to browser)
Playlist
Uploads from ExcelGuru · ExcelGuru · 0 of 60
← Previous
Next →
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
Total Sumproduct Session By Excel Expert Mr.Sanjeev kaushik
ExcelGuru
Finding operators,Location with multiple serial numbers as text
ExcelGuru
Uses and Technics of Transpose in 3 Methods
ExcelGuru
Query Solved ExcelExpert
ExcelGuru
MIS QUERY
ExcelGuru
Amazing Query with solution By me
ExcelGuru
Soution For Query
ExcelGuru
counting numbers and text with creteria lenngth
ExcelGuru
For Reverse Looking Fing age By Using Database Function
ExcelGuru
MIS INTERVIEW QUESTION EXTRACTING FIRST AND LAST NAME WHICH IS NOT HAVING DELIMETER
ExcelGuru
finding Unique count of sales between Dates
ExcelGuru
counting 2 lookup values as per dupicates
ExcelGuru
Reverse Vlookup to get DOB
ExcelGuru
17-04-2022 Sridevi Marriage Celebrations
ExcelGuru
INTERVIEW QUERIES WITH ANOTHER QUERY
ExcelGuru
finding maximum sales of product when duplicate products
ExcelGuru
QUERY ASKED IN GROUP
ExcelGuru
MIS TEST WITH AMAZING SOLUTION BY JR.BILLGATES(ANAND)
ExcelGuru
query to count not saled products after saled products
ExcelGuru
Explanation about birla mandir at Hyderabad
ExcelGuru
counting specific weekday in between dates
ExcelGuru
Extract Data As per Creteria with power Query
ExcelGuru
Extracting data as per creteria in different sheets
ExcelGuru
SOLUTION FOR INPHOSYS MIS-1(1-4)
ExcelGuru
solution for inphosis mis 2(12-13)
ExcelGuru
INPHOSIS MIS SOLUTION-3(5-10)
ExcelGuru
LOGICAL MIS INPHOSIS-4(17-18)
ExcelGuru
MIS INTERVIEW QUESTION
ExcelGuru
MIS INPHOSIS -5(19-21)
ExcelGuru
MIS INPHOSIS - 6(23-25)
ExcelGuru
extracting pin codes or number from text string
ExcelGuru
finding maximum sales in one value
ExcelGuru
finding how many months are there between months
ExcelGuru
Quarter sales by month
ExcelGuru
Finding rate with 2 conditions by using vlookup
ExcelGuru
how to find max length word from text string
ExcelGuru
Group query To find sales and Quantity With 2 conditions by using VLOOKUP
ExcelGuru
my angels birthday celebrations
ExcelGuru
Group Query Adding total sales when it is having random delimiter like inches,kgs,Ton
ExcelGuru
Seperating first and last Name by space using function
ExcelGuru
Finding Total Goals from different tables Team members
ExcelGuru
Group Query To Extract Team members Names
ExcelGuru
Extracting data in a single column
ExcelGuru
converting one column data into table interview question
ExcelGuru
MIS INTERVIEW QUESTION-100
ExcelGuru
MIS INTERVIEW QUESTION -101 FINDING VALUE AS PER CHARACTERS LENGTH BY VLOOKUP
ExcelGuru
chi.shreyansh
ExcelGuru
MIS INTERVIEW QUESTION-102(SORT BY LENGTH)
ExcelGuru
query to extract last words from sentence
ExcelGuru
MIS INTERVIEW -103(EXTRACT MAXIMUM CHARACTERS WORD IN A CELL)
ExcelGuru
chandrayana 3
ExcelGuru
group query
ExcelGuru
my new youtube channel
ExcelGuru
without len function count of characters
ExcelGuru
MIS QUERY
ExcelGuru
MIS GURU CLASSES
ExcelGuru
SAP INTRODUCTION
ExcelGuru
SAP CLASS 1
ExcelGuru
mis interview questions part -1
ExcelGuru
Real MIS Query-1
ExcelGuru
DeepCamp AI