Get instant live expert help on subtotal vs total

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

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 am trying to have a % of grand total based on a subtotal within a pivot table
Solved by Z. U. in 12 mins