G
Guest
Need a formula to enter on Report Sheet under Month as indicated from tables below. The data base worksheet has info inserted daily and the report will be on another worksheet to calculate as data is updated. Any ideas??
(Need total paid for all rows paid to Name 1 with dates in month of Jan)
Data Base Worksheet Report Sheet
NAME DATE PAID NAME JAN FEB
Name 1 01/01/04 $200.00 Name 1 ??Paid ??Paid
Name 1 01/22/04 $200.00 Name 2 ??Paid ??Paid
Name 2 01/15/04 $200.00
Name 1 02/04/04 $200.00
(Need total paid for all rows paid to Name 1 with dates in month of Jan)
Data Base Worksheet Report Sheet
NAME DATE PAID NAME JAN FEB
Name 1 01/01/04 $200.00 Name 1 ??Paid ??Paid
Name 1 01/22/04 $200.00 Name 2 ??Paid ??Paid
Name 2 01/15/04 $200.00
Name 1 02/04/04 $200.00