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!
please let me know how you do it!
Try using SUMIF. That is what I use to sum by a number or name. Works fine.
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.
ASKER
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.
You might consider enumerating the names in another column as using SUMIF with numbers is more compact than names.
ASKER
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.
=SUMIF(L$63:L$92,V68,I$63:
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
THANKS