Can't get formula to work using a range A:D

[drumz]

This works:

=SUM(July!H39+G8+G9+G10+G11+G12+G13+G14)*(B41)

But this does not:

=SUM(July!H39)*(B41)+(G8:G14)*(B41)

Nor does this:

=SUM(July!H39)+(G8:G14)*(B41)

And this doesn't either:

=SUM(July!H39+G8:G14)*(B41)

Can someone explain why it does not like me putting a range in there?

Thanks very much!

 

[Nalani]

Try this:

=SUM(July!H39)+Sum(July!G8:G14)*(B41)

My assumption is B41 is not on your July sheet, and you are trying to add a range from July and multiplying by what is in B41 of the unknown sheet.

 

[Michael M]

Also

=SUM(July!H39,G8:G14)*B41

 

[drumz]

This is a spreadsheet that computes working hours through the year with a pay period every 2 weeks. This formula grabs the totals of a range on the July worksheet then adds a couple from the current range and multiplies. The one you gave me has a total but not the right one.
B41 is on the same sheet and it is the number 25, the multiplier. This multiplier is identified on the first sheet and B41 on this sheet references that cell which references the number 25 (this way if the rate increases (I will no longer be available for them if they try to lower it) I only have to change 1 cell).
So July!H39 is really the range July!G32:July!G39 (2.5 hours). Then on the current sheet I have another range G8:G14 (.5 hours). And those totals I want to multiply by 25. Each way I try it that is wrong I get 69.50 except for the one that works which is 75. And the one you gave me gave a total of 2.5.

It works they way I did it without using a range or using a range then getting the total in another cell and then referencing that cell.
So if I go July!H39 = July!G32:July!G39 and H14 = G8:G14 it works
=sum(July!H39+H14)*(B41)

Any ideas why it is acting like that? Not that it matters but running Office 2007

 

[drumz]

Michael,
That worked! I can see using the comma is like an and.

Thanks