I have a spreadsheet for the month of May.
Every time there is a piece of equipment gone out for the month, we put 1.00 against the date.
However, there is a minimum set that is sent out even though we have a 1.00 against the date to mark its gone out the qty might be 4.
I need to work out the total amount we bill each day, instead of for each piece of equipment at the end of the month and any formula I try I keep getting errors.
It is only to calculate if there is a 1 in the box on the date and it’s the total for that day for each piece of equipment.
I hope I explained this ok
Bookmarks