Link to home
Start Free TrialLog in
Avatar of finnstone
finnstone

asked on

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!
Avatar of John
John
Flag of Canada image

Try using SUMIF. That is what I use to sum by a number or name. Works fine.
Avatar of CompProbSolv
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.
Avatar of finnstone
finnstone

ASKER

this is attached

thanks
pedbroken.xlsx
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.
COULD SOMEONE TAKE A CRACK AT THE WORKBOOK? THANKS
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.
ASKER CERTIFIED SOLUTION
Avatar of Ejgil Hedegaard
Ejgil Hedegaard
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
THANKS