Using this formula I can get a daily total but cannot make it work to find
the monthly total:

=SUMPRODUCT(--(LEFT(Overall!$C$8:$C$3000,2)="Cl"),--(Overall!$F$8:$F$3000=A5)*(Overall!$S$8:$S$3000=C1 ),Overall!$W$8:$W$3000)

C1 is where I have the date entered. 10/1/2009. That will only find that
day's total. What do I need to add to the formula so that it looks for the
whole month?

Thanks for the assistance.

Replace this:

*(Overall!$S$8:$S$3000=C1)

With this:

,--(TEXT(Overall!$S$8:$S$3000,"mmyyyy")=TEXT(C1,"mmyy yy"))

--
Biff
Microsoft Excel MVP


"roy.okinawa" wrote in message
...
Using this formula I can get a daily total but cannot make it work to find
the monthly total:

=SUMPRODUCT(--(LEFT(Overall!$C$8:$C$3000,2)="Cl"),--(Overall!$F$8:$F$3000=A5)*(Overall!$S$8:$S$3000=C1 ),Overall!$W$8:$W$3000)

C1 is where I have the date entered. 10/1/2009. That will only find that
day's total. What do I need to add to the formula so that it looks for
the
whole month?

Thanks for the assistance.

Try the below

=SUMPRODUCT(--(LEFT(Overall!$C$8:$C$3000,2)="Cl"),
--(Overall!$F$8:$F$3000=A5),
--(TEXT(Overall!$S$8:$S$3000,"mmyy")=text(C1,"mmyy") ),
Overall!$W$8:$W$3000)


If this post helps click Yes
---------------
Jacob Skaria


"roy.okinawa" wrote:

Using this formula I can get a daily total but cannot make it work to find
the monthly total:

=SUMPRODUCT(--(LEFT(Overall!$C$8:$C$3000,2)="Cl"),--(Overall!$F$8:$F$3000=A5)*(Overall!$S$8:$S$3000=C1 ),Overall!$W$8:$W$3000)

C1 is where I have the date entered. 10/1/2009. That will only find that
day's total. What do I need to add to the formula so that it looks for the
whole month?

Thanks for the assistance.