cannot get subtotal to work

subtotal is not adding numbers (using sum) by name of practice. it just outputs 0s.

please let me know how you do it!
finnstoneAsked:
Who is Participating?
 
Ejgil HedegaardConnect With a Mentor Commented:
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
 
JohnBusiness Consultant (Owner)Commented:
Try using SUMIF. That is what I use to sum by a number or name. Works fine.
0
 
CompProbSolvCommented:
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
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
finnstoneAuthor Commented:
this is attached

thanks
pedbroken.xlsx
0
 
JohnBusiness Consultant (Owner)Commented:
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
 
finnstoneAuthor Commented:
COULD SOMEONE TAKE A CRACK AT THE WORKBOOK? THANKS
0
 
JohnBusiness Consultant (Owner)Commented:
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
 
finnstoneAuthor Commented:
THANKS
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.