# Sum Total of Date Range in Pivot Table

#### heretolearnexcel

##### New Member
I want total sales for each sku in a specific date range. But what I get is daily sales excluding the daily sales that are not in the date range. So I then group the daily sales into years, so that I only get the total yearly sales for each item, and I get this.
JKL
4DATESKUSALES
52018A10
6B20
7C35
8D10
9E15
10F12
11G13
12H6
13I7
142019A5
15B9
16C13
17D23
18E12
19F15
20G19
21H12
22I13
23Grand Total249

</tbody>
Tabla Dinámica

But this way I will still have to sum the total sales in 2018 and 2019 for each sku. What I want is to get total sales in the date range, not broken down in years or whatever. Like this:
OP
4SKUSALES
5A15
6B29
7C48
8D33
9E27
10F27
11G32
12H18
13I20
14A254
15B9
16C13
17D23
18E12
19F15
20G19
21H12
22I13
23Grand Total619

</tbody>
Tabla Dinámica

Worksheet Formulas
CellFormula
P5=L5+L14
P6=L6+L15
P7=L7+L16
P8=L8+L17
P9=L9+L18
P10=L10+L19
P11=L11+L20
P12=L12+L21
P13=L13+L22
P14=L14+L23
P15=L15+L24
P16=L16+L25
P17=L17+L26
P18=L18+L27
P19=L19+L28
P20=L20+L29
P21=L21+L30
P22=L22+L31
P23=SUM(P5:P22)

</tbody>

<tbody>
</tbody>

How can I achieve this?
Note: the grand totals are irrelevant because I don't want the total sales of all the items, only the total sales of each item.

### 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.

Any ideas?

#### heretolearnexcel

##### New Member
I still cannot figure out a solution.

Bump

#### heretolearnexcel

##### New Member
Is there something missing from my explanation to make it clear?

1,095,170
Messages
5,442,799
Members
405,198
Latest member
Florence Thomas

### This Week's Hot Topics

• Copy entire row if CountA <>0 to another sheet
[B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
• Select last used Row in Table
I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
• excel workbook: do not allow certain file name
Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
• fixing problem autofilter
hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
• “Weight”
Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
• How to capitalize everything before a certain character?
In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...