'SUM' Tables

M

masster

Hello

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

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

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

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

Is it possible?

Awaiting for your expert help.
Thank yo
 
P

Paul Sheppard

masster said:
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
Click to expand...


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
 
M

masster

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

Anybody else? More experienced
 
P

Paul Sheppard

masster said:
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?
Click to expand...

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
 
M

masster

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, yo
scumbag..
 
Top