I tried to figure how to use a SumIf but that did not work.
All the dates are in column D and the item description that says Rent is in column C. The value to be summed is in column E.
Sample data for C, D and E:
Rent, 01/02/15, $400.00
Rent, 01/05/15, $375.00
Mgt Fees, 01/08/15, $62.00
Rent, 02/06/15, $500.00
Mgt Fees, 02/06/15, $40.00
Late Fees, 02/18/15, $275.00
Mgt Fees, 02/18/15, $47.00
Leasing Fee, 02/18/15, $150.00
Rent, 03/10/15, $400.00
Mgt Fees, 03/13/15, $32.00
Late Fees, 03/30/15, $50.00
Late Fees, 03/30/15, $375.00
Mgt Fees, 03/31/15, $55.00
Taxes, 03/25/15, $45.83
I don't think that it maters but this formula will go into column H.
Thank you!
All the dates are in column D and the item description that says Rent is in column C. The value to be summed is in column E.
Sample data for C, D and E:
Rent, 01/02/15, $400.00
Rent, 01/05/15, $375.00
Mgt Fees, 01/08/15, $62.00
Rent, 02/06/15, $500.00
Mgt Fees, 02/06/15, $40.00
Late Fees, 02/18/15, $275.00
Mgt Fees, 02/18/15, $47.00
Leasing Fee, 02/18/15, $150.00
Rent, 03/10/15, $400.00
Mgt Fees, 03/13/15, $32.00
Late Fees, 03/30/15, $50.00
Late Fees, 03/30/15, $375.00
Mgt Fees, 03/31/15, $55.00
Taxes, 03/25/15, $45.83
I don't think that it maters but this formula will go into column H.
Thank you!