jdavid1006
New Member
- Joined
- Oct 21, 2019
- Messages
- 6
Hi guys,
Although I've been reading for a number of years, this is my first post. Please bear with me if I do something incorrectly.
I have a workbook that is basically taking invoices and rolling them up by date, truck number, and expense type. The problem is there can be multiple invoices in a month. I think I need to use the sumproduct formula but I'm not super familiar with it.
I have a summary that looks like the table below but I need to see everything by month and YTD. I can still have the Truck and Type columns (brakes, tires, etc...). Any ideas on what I can do? Thank you!
<tbody>
</tbody>
Although I've been reading for a number of years, this is my first post. Please bear with me if I do something incorrectly.
I have a workbook that is basically taking invoices and rolling them up by date, truck number, and expense type. The problem is there can be multiple invoices in a month. I think I need to use the sumproduct formula but I'm not super familiar with it.
I have a summary that looks like the table below but I need to see everything by month and YTD. I can still have the Truck and Type columns (brakes, tires, etc...). Any ideas on what I can do? Thank you!
Invoice 123 | Invoice 456 | Invoice 789 | ||
August | August | September | ||
Truck 1 | Brakes | 50 | ||
Truck 2 | Tires | 100 | ||
Truck 2 | Maintenance | 25 | 25 | 25 |
Truck 3 | Brakes | 50 | ||
Truck 4 | Maintenance | 25 | 25 |
<tbody>
</tbody>