Insert Subtotals Command

[nicolachen]

Hi I ran into a problem, it state "Use the subtotals command to sum the totals for each sales person) *Hint: convert the list to a normal range before calculating the subtotals.

I highlight Sales person and click Date but subtotals key is not showing up. dunno why? can some one help, i have attach the file its in the Subtotals worksheet. thank you

[davesexcel]

Subtotal adds only what you have filtered
example
=SUBTOTAL(9,J5:J79)

enter
=subtotal(
then hit the function wizard the fx beside the formula bar, then click on help with this function to see what you can do with subtotal function

[nicolachen]

Hi Dave I try your fomula but the grand total doesn't add up right
The grand total suppose to be $8003.77 but i got $6290.82 dunno what i did wrong? can you check for me. i have attach the file thanks

[VBA Noob]

Use excel built in subtotal to avoid human errors. e.g

your formula should being J82 not J81

=J23+J39+J56+J67+J82

http://www.bettersolutions.com/excel...A823711331.htm



VBA Noob

[corinereyes]

Hi nicolachen,

Where did you get your total "8003.77", the total (correct me if im wrong) is "7707.96" in your spreadsheet when i used grouping for the subtotals.

See the attached file, then select J83 of sheet named Subtotal.

[nicolachen]

Hi nicolachen,

Where did you get your total "8003.77", the total (correct me if im wrong) is "7707.96" in your spreadsheet when i used grouping for the subtotals.

See the attached file, then select J83 of sheet named Subtotal.

Hi Corinereyes
I look over the sheet there's missing data i just correct it, I got my PivotTable Grand Total $8003.77 but I still can't get the subtotal Grand Total. I try your formula but i got ##### what i did wrong???? please help....


VBA Noob (I try your formula i got $2535.35 wasn't even close to the Total show in the book $8003.77 ) u sure its the right formula?

[VBA Noob]

Your calc of $8003.77 is wrong. Both corinereyes and my total is $7,707.96 as per my attachment. The formula was your formula showing you that you had referenced a cell wrong.

As I said use excel built in function to avoid these mistakes as per my example

VBA Noob

[nicolachen]

the attach file above is the wrong one, here's the right one