Get instant live expert help on I need help with total vs subtotal
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I have a range of data that I need to subtotal based on if it is yes or no. So person a total # of results (subtotal) but then within that subtotal how many yes and how many no. I know I can subtotal three times but was looking for one formula.
Solved by O. E. in 25 mins
Qty Part Number Description Price Total Subtotal: #N/A
1 3009 ALFALFA, LEAF, Powder $3.05 3.05 Tax: #N/A
Total Order: #N/A
Qty Part Number Description Price Total Subtotal: #N/A
1 AFRICAN BIRD PEPPER, FRUIT, Whole #N/A #N/A Tax: #N/A
Total Order: #N/A
I want the formula to read as the second part
Solved by B. H. in 18 mins
How do I place a subtotal and grand total at the top of the pivot table?
Solved by V. U. in 18 mins
I need you to calculate the following:
Total Number of Clients in each year
Number of New Clients in current year vs previous
Number of Clients lost in current year vs the prior year
Solved by I. C. in 14 mins
I want to setup my pviot to auto-calculate to view difference in PV Table vs. Grand Total.
Difference in sum of quantity instead of grand total.
Solved by Z. C. in 24 mins