Solved

cannot get subtotal to work

Posted on 2016-11-26
8
18 Views
Last Modified: 2016-11-27
subtotal is not adding numbers (using sum) by name of practice. it just outputs 0s.

please let me know how you do it!
0
Comment
Question by:finnstone
8 Comments
 
LVL 90

Expert Comment

by:John Hurst
ID: 41902326
Try using SUMIF. That is what I use to sum by a number or name. Works fine.
0
 
LVL 20

Expert Comment

by:CompProbSolv
ID: 41902484
No obvious answer from your limited information.  It would be very helpful if you could post the spreadsheet with a comment about where the subtotal isn't working.
0
 

Author Comment

by:finnstone
ID: 41902698
this is attached

thanks
pedbroken.xlsx
0
 
LVL 90

Expert Comment

by:John Hurst
ID: 41902710
Use SUMIF using column C to match on and column E to for the data if that is what you mean.

You might consider enumerating the names in another column as using SUMIF with numbers is more compact than names.
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 

Author Comment

by:finnstone
ID: 41903148
COULD SOMEONE TAKE A CRACK AT THE WORKBOOK? THANKS
0
 
LVL 90

Expert Comment

by:John Hurst
ID: 41903166
You need a formula like this.

=SUMIF(L$63:L$92,V68,I$63:I$92)

Where L is the index; V is the match cell, and I is the selection to be matched.

Try this in your spreadsheet and it will work.

If you need someone to write a spreadsheet for you, set up a GIG for it.
0
 
LVL 21

Accepted Solution

by:
Ejgil Hedegaard earned 500 total points
ID: 41903245
The "values" you subtotal are text, not numbers, so subtotal results are 0.
See attached file where values are changed to numbers.
-pedbroken.xlsx
0
 

Author Closing Comment

by:finnstone
ID: 41903247
THANKS
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now