sum values

I would like to get the best approach to summing values  like.

workbook attached
book-one-test.xlsb
SvgmassiveAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
ProfessorJimJamConnect With a Mentor Commented:
I think my solution is the correct one.  all others does not show the correct outcome :-)

check the attached file.
EE.xlsb
0
 
Rgonzo1971Commented:
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
 
SteveCommented:
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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Rgonzo1971Commented:
@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
 
ProfessorJimJamCommented:
@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
 
ProfessorJimJamCommented:
with three different formats attached. :-)
0
All Courses

From novice to tech pro — start learning today.