I manage a Monthly Sales Log with at least 20 columns of information. I have
the listed set-up with Auto-Filter, and many columns have validation lists.

I also have a monthly MASTER DOC, which itemizes activity for each day.
This activity is logged into the MSL.

The problem I have is this:

If we sell a product on 11/1, but it is NOT DELIVERED until 11/5, how do I
get the MASTER DOC to recognize the INCOME AMOUNT on the correct day? I need
to be able to record the activity of EACH DAY, but only record the INCOME, or
CANCEL or DELIVERY, on the DAY THE 2nd or 3rd activity occurs. Bear in mind
that many of the deals are also New vs. Used, etc.

I need it basically to compute something akin to:

if a=11/1, AND c=new, AND f=DEL, then post $i4:$i300. Something to that
effect.

I sure hope someone knows what the heck I just said! Thanks.

I'm not completely sure, but your basic statement sounds like something you
could use a SUMPRODUCT on, by multiplying the different columns.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html#new
--
Best Regards,

Luke M


"RobL" wrote:

I manage a Monthly Sales Log with at least 20 columns of information. I have
the listed set-up with Auto-Filter, and many columns have validation lists.

I also have a monthly MASTER DOC, which itemizes activity for each day.
This activity is logged into the MSL.

The problem I have is this:

If we sell a product on 11/1, but it is NOT DELIVERED until 11/5, how do I
get the MASTER DOC to recognize the INCOME AMOUNT on the correct day? I need
to be able to record the activity of EACH DAY, but only record the INCOME, or
CANCEL or DELIVERY, on the DAY THE 2nd or 3rd activity occurs. Bear in mind
that many of the deals are also New vs. Used, etc.

I need it basically to compute something akin to:

if a=11/1, AND c=new, AND f=DEL, then post $i4:$i300. Something to that
effect.

I sure hope someone knows what the heck I just said! Thanks.