I am trying to put together a formula to sum multiple columns of data found
on a different tab. For example, the "Data" tab has three columns with 15
rows of data. I want to sum column A, B and C; then add A and B and divide
by C.

Here is what I'm trying to work with:
=(Sum(Sum(Data!A:A)+(Sum(Data!B:B))/(Sum(Data!C:C)))

But I'm getting a different total than when I do the same calculation on the
tab with the data.

Any assistance would be appreciated!!

try
=sum(data!a:b)/sum(data!c:c)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"SMH" wrote in message
...
I am trying to put together a formula to sum multiple columns of data found
on a different tab. For example, the "Data" tab has three columns with 15
rows of data. I want to sum column A, B and C; then add A and B and
divide
by C.

Here is what I'm trying to work with:
=(Sum(Sum(Data!A:A)+(Sum(Data!B:B))/(Sum(Data!C:C)))

But I'm getting a different total than when I do the same calculation on
the
tab with the data.

Any assistance would be appreciated!!

Watch your ()'s:

=SUM(SUM(Data!A:A)+(SUM(Data!B:B)))/SUM(Data!C:C)

or just:
=SUM(Data!A:B)/SUM(Data!C:C)

I think????

and
=SUM(Data!A:C)

should do the first part of the question.

SMH wrote:

I am trying to put together a formula to sum multiple columns of data found
on a different tab. For example, the "Data" tab has three columns with 15
rows of data. I want to sum column A, B and C; then add A and B and divide
by C.

Here is what I'm trying to work with:
=(Sum(Sum(Data!A:A)+(Sum(Data!B:B))/(Sum(Data!C:C)))

But I'm getting a different total than when I do the same calculation on the
tab with the data.

Any assistance would be appreciated!!

--

Dave Peterson