[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
Solved

# cannot get subtotal to work

Posted on 2016-11-26
Medium Priority
38 Views
subtotal is not adding numbers (using sum) by name of practice. it just outputs 0s.

please let me know how you do it!
0
Question by:finnstone
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 98

Expert Comment

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

LVL 22

Expert Comment

ID: 41902484
0

Author Comment

ID: 41902698
this is attached

thanks
pedbroken.xlsx
0

LVL 98

Expert Comment

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

Author Comment

ID: 41903148
COULD SOMEONE TAKE A CRACK AT THE WORKBOOK? THANKS
0

LVL 98

Expert Comment

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.

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

LVL 23

Accepted Solution

Ejgil Hedegaard earned 2000 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

ID: 41903247
THANKS
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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â€¦
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns overâ€¦
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calculâ€¦
###### Suggested Courses
Course of the Month12 days, 21 hours left to enroll