SUM IF ?.... Assistance to calculate total sales/profit according to a 'Supplier' column

Hello

I am trying to calculate Total Sales and Gross profit across a number of records according to supplier column:

Hope this illustrates what I am trying to achieve.... grateful for any assistance with the right formula..

Capture_kp.JPG

Hi,

You can use SUMIF for this.

In cell C12 and copy down.

Please Login or Register  to view this content.

In Cell D12 and copy down.

Please Login or Register  to view this content.

See attached example.

Hope this is helpful.

Cheers

Hi southward

Yes very helpful thanks!

Can you assist further?
Can I have a row in my results after the ones in my picture which 'pulls in' the sales & profit figures for 'Any other supplier not in the rows above'..
..in other words I want to have the 3 'main' suppliers (SDOR001, SBAB001 & SFES001) shown individually and then a row for 'Other suppliers'

Hope that makes sense .... and is achievable!

Cheers

Yes. You can do this. Use this formula for Others :
For Total Sales Amount :

Please Login or Register  to view this content.

For Total Gross Profit :

Please Login or Register  to view this content.