'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

masster Wrote:
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


Hi Masster

Just a suggestion, instead of 7 tables with 4 columns, have 1 table
with 5 columns, the extra column being the day eg Monday etc or date

You could then get the info you wanted by running a pivot Table


--
Paul Sheppard


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

Paul Sheppard Wrote:
Just a suggestion, instead of 7 tables with 4 columns, have 1 table with
5 columns, the extra column being the day eg Monday etc or date. You
could then get the info you wanted by running a pivot Table
________________
Hope this helps
No, Paul. It doesn't help. AT ALL. The tables I mentioned are outputed
by Linux OS, and I guess you don't want me to modify the Linux kernel
and recompile it...

Anybody else? More experienced?


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

masster Wrote:
No, Paul. It doesn't help. AT ALL. The tables I mentioned are outputed
by Linux OS, and I guess you don't want me to modify the Linux kernel
and recompile it...

Anybody else? More experienced?

Hey you ignorant B**tard, don't take this "your not good enough
attitude" when you don't get the answer you want, if your original
description of what you wanted had been a bit better then maybe you'd
have got the answer you were looking for

I notice that you still haven't got the answer you seek, probably
because of your attitude. Everybody on this forum is really happy to
frreely give up a little of their time to help others, but don't take
kindly to people on here with bad attitudes and rightly ignore them


--
Paul Sheppard


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

Paul Sheppard.

F.U.C.K. you too with your mother hooker.
You're more stupid than I thought. And suffer of a too big ego, you
scumbag...


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