G
Guest
First off, I am not an accounting pro or an Excel daily user so please adjust your answers accordingly
I keep a monthly expense sheet for my business based on the date of the expense not the vendor. Headers are as follows
date vendor itemized item purchased cost/item item count total cost of item total cost of orde
Right now I input the date, vendor and first item purchased, cost/1, and calculate the total cost of the line item for each line from the vendor. I only put the vendor name in one time for each order even though I have multiple line items from the vendor. When I enter the last line item I hand calc the total cost of the order
My question is as follows
How do I tell Excel to write a formula to calc the total cost of the order? It will need to either look for a vendor change if only a single line item is entered or it will need to look for a vendor change and the back up to the cell above which would be empty and then total from the last vendor to the last blank vendor line in that set.
Will Excel do this
Thanks Matt
I keep a monthly expense sheet for my business based on the date of the expense not the vendor. Headers are as follows
date vendor itemized item purchased cost/item item count total cost of item total cost of orde
Right now I input the date, vendor and first item purchased, cost/1, and calculate the total cost of the line item for each line from the vendor. I only put the vendor name in one time for each order even though I have multiple line items from the vendor. When I enter the last line item I hand calc the total cost of the order
My question is as follows
How do I tell Excel to write a formula to calc the total cost of the order? It will need to either look for a vendor change if only a single line item is entered or it will need to look for a vendor change and the back up to the cell above which would be empty and then total from the last vendor to the last blank vendor line in that set.
Will Excel do this
Thanks Matt