software

I have the following info setup, I need to be able to sum by customer for
each month. The days represent shipping volumes for each day. This same
setup is repeated through out the spreadsheet until the end of the year. How
or can this be done?

FriSat.MonTuesWedThur
SHIP DAY30-Dec31-Dec2-Jan3-Jan4-Jan5-Jan
Toyota00645
Ford0138150
Honda144013841432
Hyundia660620660
Chrysler0284292288
Nissan0120140120
Maybe something like this:

=SUMPRODUCT((MONTH(B11)=12)*(A2:A11=E3),B211)

where E3 is the product to lookup, B11 in the ship day row, A2:A11 is
the product list and B211 is your range with number of product
shipped.

HTH
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=497552That worked for the one table but I have the same table repeated for each
week of the month. This pattern is repeated until Dec 31. I need to be able
to add all quantities for each customer for each month. Thanks

FriSat.MonTuesWedThur
SHIP DAY30-Dec31-Dec2-Jan3-Jan4-Jan5-Jan
Toyota00645
Ford0138150
Honda144013841432
Hyundia660620660
Chrysler0284292288
Nissan0120140120
FriSat.MonTuesWedThur
SHIP DAY06-Jan07-Jan9-Jan10-Jan11-Jan12-Jan
Toyota00645
Ford0138150
Honda144013841432
Hyundia660620660
Chrysler0284292288
Nissan0120140120quot;pinmasterquot; wrote:

gt;
gt; Maybe something like this:
gt;
gt; =SUMPRODUCT((MONTH(B11)=12)*(A2:A11=E3),B211)
gt;
gt; where E3 is the product to lookup, B11 in the ship day row, A2:A11 is
gt; the product list and B211 is your range with number of product
gt; shipped.
gt;
gt; HTH
gt; JG
gt;
gt;
gt; --
gt; pinmaster
gt; ------------------------------------------------------------------------
gt; pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
gt; View this thread: www.excelforum.com/showthread...hreadid=497552
gt;
gt;


To be honest, I'm not even sure it's possble, it's more a task for the
MVP's out there. So if anyone of those MVP's see's this maybe you could
help. Sorry Icouln't help you.

Regards
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=497552
Ok I've been working on this for awhile and I was able to come up with
something, it's too much to put down in a post so I'm attaching a
sample worksheet with notes.

Note: I'm assuming that your product list is in the same order all the
way down your range and there are no gaps (blank rows). Also you may
need to alter the formulas so that they pull the data from the correct
rows. In my sample worksheet the first dates are in row 4 and product
list starts in row 5.

Hope it's something you can use.

Regards
JG -------------------------------------------------------------------
|Filename: month by month sales sample.zip |
|Download: www.excelforum.com/attachment.php?postid=4181 |
-------------------------------------------------------------------

--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=497552