Hi All,
never used a site like this before.
need assistance with calcuating the tolat amount earned on a car rental between the dates an owner has the car listed.
Column B & D have intentionall been left blank.
example: Car rego xcvbn was listed by the owner between 10/5/15 & 7/6/15 and then again from 30/7 - 30/8
that same car has been rented 3 times. twice during the first listing and once during the second listing.
I need to tally up to amount eared from the rental during each listing. ie from 10/5-7/6 the total earned is $1000 and from30/7 - 30/8 the total earned is $300.
Can anyone help me with a formula? i've been tinkering with Sumif and median... but no luck
Owner
A B C D E
1 Date listed Date collected Rego #
2 15/05/2015 27/05/2015 sdfgh
3 5/06/2015 8/07/2015 dfghj
4 15/05/2015 7/06/2015 xcvbh
5 20/05/2015 20/06/2015 bvcxz
6 30/07/2015 30/08/2015 xcvbh
Renter
A B C D E F
1 Rental start date Rental end date Rego # Amount earned
2 20/05/2015 25/05/2015 xcvbh $100
3 6/06/2015 3/07/2015 dfghj $300
4 25/05/2015 30/05/2015 xcvbh $900
5 30/05/2015 7/06/2015 bvcxz $100
6 20/05/2015 25/05/2015 sdfgh $200
7 1/08/2015 6/08/2015 xcvbh $300
Thanks
Bookmarks