LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
SMH SMH is offline
external usenet poster
 
Posts: 29
Default Sum Multiple Tabs of Data

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!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create multiple sheet tabs from multiple cells. Robert Maddox Excel Worksheet Functions 17 November 14th 07 10:28 PM
Charting data in the same column on multiple tabs Bob Hopson Charts and Charting in Excel 1 February 7th 07 06:18 PM
How do I use VLOOKUP to ref multiple workbooks with multiple tabs? JackieW Excel Discussion (Misc queries) 2 April 11th 06 05:32 PM
Combining Data multiple tabs zero760 Excel Discussion (Misc queries) 2 August 30th 05 11:00 PM
How to pull data out of an excell file with multiple tabs mdeanda Excel Worksheet Functions 1 May 28th 05 02:21 AM


All times are GMT +1. The time now is 02:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"