Solved

# sum values

Posted on 2014-11-03
66 Views
I would like to get the best approach to summing values  like.

workbook attached
book-one-test.xlsb
0
Question by:Svgmassive
• 3
• 2

LVL 48

Expert Comment

Hi,

You could create a Table by selecting your range and Insert / Tables / Table

and the use  formula

``````=SUM(Table1[A],Table1[b],Table1[c])
``````
Regards
book-one-testV1.xlsb
0

LVL 24

Expert Comment

You can use the following array formulas
Entered using [ctrl]+[shift]+[enter]...

=SUM(\$D\$5:\$I\$8,N(D4:I4<>"*rem"))
=SUM(\$D\$5:\$I\$8,N(D4:I4="*rem"))

See attached
U--book-one-test.xlsb
0

LVL 25

Accepted Solution

ProfessorJimJam earned 500 total points
I think my solution is the correct one.  all others does not show the correct outcome :-)

check the attached file.
EE.xlsb
0

LVL 48

Expert Comment

@JimJam

You do not show the total sum of hours but only the rest of division by day 6: 00 instead of 30:00

You have not changed the format like I did [hh]:mm ;-)
0

LVL 25

Expert Comment

@Rgonzo1971

by all means, your number is also correct. sorry did not see the format ;-)  but you can agree with me that sum product is dynamic, if you change the title of the header by either adding *rem or otherway around removing the rem, then your table sum is not updated, whereas the sumproduct catches that one :-)

anyways, you are the genius
0

LVL 25

Expert Comment

with three different formats attached. :-)
0

## Join & Write a Comment Already a member? Login.

### Suggested Solutions

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

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

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

#### Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!