I am trying to write a formula that would sum up the total amounts based on the invoice id changing (see table below). I additionally, have a quantity that needs to be multiplied by the amount and then sum the total. The Invoice ID does not copy down so it needs to change when it finds the next Invoice ID to calculate again.
It is always a good idea to include your expected results so that we know what they are and where they are.
I am not sure if you are looking for those intermediate columns that @RasGhul has included?
If not and you just want the invoice totals, then perhaps this?
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.