sumifs with pivot table

J

jbrown021286

Board Regular
Joined
Mar 13, 2023
Messages
85
Office Version
  1. 365
Platform
  1. Windows
Qlik Sense - Key Product Details by Store - Mar 2024 MTD - March 12, 2024.xlsx
ABCDEFGHIJ
2Gentle,JesseJakeJennMiraLinzAndreTerenceRonnellEvan
3Air Filter17
4Cabin Filters
5Wipers
6Brakes
7Tires
8Battery
Sheet2
Cell Formulas
RangeFormula
B3B3=SUMIFS(Sheet1!K:K,Sheet1!D:D,B2,Sheet1!G:G,A3)

Qlik Sense - Key Product Details by Store - Mar 2024 MTD - March 12, 2024.xlsx
ABCDEFGHIJKL
1StoreRO NumberDateAdvisorTechnicianHas Labor?CategoryOP CodeMultiplierKey Product ROsKey Product ROs * MultiplierTotal CP ROs
2110 - Stonecrest Honda62062033/4/2024Walker,RobertHem,PeterYTires1TIRE1111
3110 - Stonecrest Honda62063283/6/2024Spikes,EvanBogle,QuenyaYTires1TIRE1111
4110 - Stonecrest Honda62063723/6/2024Mckibben,TerenceDobson,JamieYTires1TIRE1111
5110 - Stonecrest Honda62064233/7/2024Wall,JenniferDobson,JamieYTires1TIRE1111
6110 - Stonecrest Honda62065803/8/2024Spikes,EvanBanks,ImmanuelYTires1TIRE1111
7110 - Stonecrest Honda62059343/1/2024Rhodes,RonnellRowan,JamesYTires2TIRE2121
8110 - Stonecrest Honda62063743/6/2024Brittian,Jemira NRedd,Tre DYTires2TIRE2121
9110 - Stonecrest Honda62064943/11/2024Mckibben,TerenceOum,RamyYTires2TIRE2.001.002.001.00
10110 - Stonecrest Honda62067543/11/2024Wall,JenniferBogle,QuenyaYTires2TIRE2.001.002.001.00
11110 - Stonecrest Honda62060053/2/2024Wall,JenniferOum,RamyYTires4TIRE4141
12110 - Stonecrest Honda62063673/6/2024Mckibben,TerenceOrtiz,AngelYTires4TIRE4141
13110 - Stonecrest Honda62064553/7/2024Wall,JenniferMartinez,David RYTires4TIRE4141
14110 - Stonecrest Honda62065323/8/2024Wall,JenniferRedd,Tre DYTires4TIRE4141
15110 - Stonecrest Honda62067573/11/2024Wall,JenniferMartinez,David RYTires4TIRE4.001.004.001.00
16110 - Stonecrest Honda62062453/4/2024Mckibben,TerenceBrown,JeffreyYCabin FilterAC091111
17110 - Stonecrest Honda62067393/11/2024Mckibben,TerenceOum,RamyYCabin FilterAC091.001.001.001.00
18110 - Stonecrest Honda62060073/1/2024Rhodes,RonnellTorres,Gerardo AYAir FilterAIR1111
19110 - Stonecrest Honda62060153/1/2024Rhodes,RonnellBanks,ImmanuelYAir FilterAIR1111
20110 - Stonecrest Honda62060183/1/2024Gentle,JesseWheeler,TevinYAir FilterAIR1111
21110 - Stonecrest Honda62060373/1/2024Gentle,JesseBrown,JeffreyYAir FilterAIR1111
22110 - Stonecrest Honda62060693/1/2024Rhodes,RonnellBanks,ImmanuelYAir FilterAIR1111
23110 - Stonecrest Honda62061013/2/2024Mckibben,TerenceBrown,JeffreyYAir FilterAIR1111
24110 - Stonecrest Honda62061043/2/2024Gentle,JesseTorres,Gerardo AYAir FilterAIR1111
25110 - Stonecrest Honda62061173/2/2024Gentle,JesseBogle,QuenyaYAir FilterAIR1111
26110 - Stonecrest Honda62061363/2/2024Gentle,JesseHem,PeterYAir FilterAIR1111
27110 - Stonecrest Honda62061423/2/2024Brittian,Jemira NTorres,Gerardo AYAir FilterAIR1111
28110 - Stonecrest Honda62061483/2/2024Brooks,AndreBanks,ImmanuelYAir FilterAIR1111
29110 - Stonecrest Honda62061553/2/2024Brooks,AndreDobson,JamieYAir FilterAIR1111
30110 - Stonecrest Honda62061563/2/2024Mckibben,TerenceTorres,Gerardo AYAir FilterAIR1111
31110 - Stonecrest Honda62061603/2/2024Brooks,AndreJones,RoderickYAir FilterAIR1111
32110 - Stonecrest Honda62061683/2/2024Brooks,AndreBanks,ImmanuelYAir FilterAIR1111
33110 - Stonecrest Honda62061713/2/2024Brooks,AndreBogle,QuenyaYAir FilterAIR1111
34110 - Stonecrest Honda62062003/4/2024Gentle,JesseRowan,JamesYAir FilterAIR1111
35110 - Stonecrest Honda62062123/4/2024Gentle,JesseBogle,QuenyaYAir FilterAIR1111
36110 - Stonecrest Honda62062163/4/2024Rhodes,RonnellBanks,ImmanuelYAir FilterAIR1111
37110 - Stonecrest Honda62062233/4/2024Gentle,JesseLewis,JustinYAir FilterAIR1111
38110 - Stonecrest Honda62062473/4/2024Mckibben,TerenceRoberts,HarryYAir FilterAIR1111
39110 - Stonecrest Honda62062573/4/2024Brittian,Jemira NBogle,QuenyaYAir FilterAIR1111
40110 - Stonecrest Honda62062683/4/2024Brittian,Jemira NBanks,ImmanuelYAir FilterAIR1111
41110 - Stonecrest Honda62062793/5/2024Spikes,EvanAlexander,CarlYAir FilterAIR1111
42110 - Stonecrest Honda62062813/5/2024Mckibben,TerenceWoods,FrederickYAir FilterAIR1111
43110 - Stonecrest Honda62062963/5/2024Mckibben,TerenceBanks,ImmanuelYAir FilterAIR1111
44110 - Stonecrest Honda62063253/5/2024Mckibben,TerenceBanks,ImmanuelYAir FilterAIR1111
Sheet1

is it possible to have a sum if function that only sums rows that show up in the pivot table when data is shown when filtering. you can see in sheet 2 B3 i am using a sumifs function and would like it to only sum column k it is showing the table is filtered. if it can be done i will just make another augment against 2 cells with dates but i figured it would look cleaner if i could do it this way
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Sort by date Sort by votes
I'm not sure I follow. That formula will only sum what is in the pivot table.
 
Upvote 0
That is correct. The formula as it sits will just total everything in colum k that meets the 2 criteria I have at this point. I am wanting to see if there is a way to add additional arguments so that if I filter the table at all it will only total the cells that are showing after filtering that meet the criteria in my formula
 
Upvote 0
If you’re using pivot table filters, there won’t be an issue. They don’t hide rows, they actually remove the data.
 
Upvote 0
You must log in or register to reply here.

Similar threads

H
  • Solved
Macro to Filter Pivot Table
Replies
2
Views
866
howard
H
T
  • Solved
Help with formula
2
Replies
12
Views
216
Snakehips
Snakehips
OvernightCellebrity
  • Solved
SUMIF slowing calculation times
2
Replies
12
Views
461
kvsrinivasamurthy
K
M
  • Question Question
Sum together the larger amount of two ranges by row
Replies
3
Views
73
Cubist
Cubist
R
  • Solved
Is it possible for an Excel formula to calculate a sum based on date ranges?
Replies
4
Views
144
Joe4
Joe4

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top