Thread: 'SUM' Tables
View Single Post
  #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