Whole month total vice daily

[roy.okinawa]

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.

 

[T. Valko]

Replace this:

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

With this:

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

 

[Jacob Skaria]

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