Solved

sum values

Posted on 2014-11-03
6
66 Views
Last Modified: 2014-11-05
I would like to get the best approach to summing values  like.

workbook attached
book-one-test.xlsb
0
Comment
Question by:Svgmassive
  • 3
  • 2
6 Comments
 
LVL 48

Expert Comment

by:Rgonzo1971
Comment Utility
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])

Open in new window

Regards
book-one-testV1.xlsb
0
 
LVL 24

Expert Comment

by:Steve
Comment Utility
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

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

check the attached file.
EE.xlsb
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 48

Expert Comment

by:Rgonzo1971
Comment Utility
@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

by:ProfessorJimJam
Comment Utility
@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

by:ProfessorJimJam
Comment Utility
with three different formats attached. :-)
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

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.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now