LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
masster
 
Posts: n/a
Default 'SUM' Tables


Hello

Here's the problem I'm asking help from the more Excel experienced
forum users:

I have 7 tables with 4 columns: IP, BytesIN, BytesOUT, BytesTOTAL.
As you already guessed, it's about daily network traffic
(7tables=7days=1week).

I have to output a weekly total report. All would be very simple if for
each daily report I'd have the same IP's, but because my network is
dynamic, one day I can delete an IP or more and another day I can add
one or more.

So i would like to end up with a single table with 4 columns: IP,
SUMofBytesIN, SUMofBytesOUT, SUMofBytesTOTAL, but this table should
have ALL IP's used in that week listed.

Is it possible?

Awaiting for your expert help.
Thank you


--
masster
------------------------------------------------------------------------
masster's Profile: http://www.excelforum.com/member.php...o&userid=26655
View this thread: http://www.excelforum.com/showthread...hreadid=399297

 
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
Filter multiple tables on the same sheet John Excel Discussion (Misc queries) 1 June 15th 05 08:22 PM
How to pull numbers from two tables with conditions? Anna Excel Worksheet Functions 1 May 14th 05 03:21 PM
Macro for Pivot Tables Thomas Excel Discussion (Misc queries) 1 March 15th 05 01:03 AM
Autofiltering multiple tables on a spreadsheet Paul Excel Worksheet Functions 1 January 26th 05 12:47 AM
How to paste Xcel tables legibly into Word . Help!! Nimo Excel Discussion (Misc queries) 1 December 14th 04 09:53 PM


All times are GMT +1. The time now is 02:15 AM.

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"