A
Annette
I used the formula for adding number of entries, but now I need to change it
to add the amounts that were collected during each month:
=SUMPRODUCT(--(MONTH(Base!$A$2:$A$1368)=9), --ISNUMBER(Lisan!$D$2:$D$1368))
A B C D
(date) (Status) (Due) (Paid)
9/2/04 30.00 40.00
9/3/04 25.00 25.00
10/1/04 15.00 12.00
Total for column D for September $65.00
How can I change the formula to add the amounts paid per month?
Thanks!
Annette
to add the amounts that were collected during each month:
=SUMPRODUCT(--(MONTH(Base!$A$2:$A$1368)=9), --ISNUMBER(Lisan!$D$2:$D$1368))
A B C D
(date) (Status) (Due) (Paid)
9/2/04 30.00 40.00
9/3/04 25.00 25.00
10/1/04 15.00 12.00
Total for column D for September $65.00
How can I change the formula to add the amounts paid per month?
Thanks!
Annette