Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Filter multiple tables on the same sheet | Excel Discussion (Misc queries) | |||
How to pull numbers from two tables with conditions? | Excel Worksheet Functions | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Autofiltering multiple tables on a spreadsheet | Excel Worksheet Functions | |||
How to paste Xcel tables legibly into Word . Help!! | Excel Discussion (Misc queries) |