Formula on how to match multiple criteria and sum up

[elaine6985]

sample.jpg

I really need your help.. My head is mixed up from Vlookup to Sum. But i can't do it to make it work. Thanks

[ramananhrm]

Please try this file.

[hemesh]

Hello elaine6985 welcome to the forum you can use below formula

SUMIFS(D2:D13,A2:A13,10,C2:C13,72.6) where D2:D13 will be summed based on criteria of reference of 10 from A2:A13 and Price of 72.6 from C2:C13

Please Click * if helped and mark thread as solved

[elaine6985]

Hello elaine6985 welcome to the forum you can use below formula

SUMIFS(D2:D13,A2:A13,10,C2:C13,72.6) where D2:D13 will be summed based on criteria of reference of 10 from A2:A13 and Price of 72.6 from C2:C13

Please Click * if helped and mark thread as solved

Hi! thanks for the reply.. What i mean is that I need the sum per reference number. This is only a sample entry but the original is more than 1000 entry.

Untitled.jpg

Thanks..

[hemesh]

Hi! thanks for the reply.. What i mean is that I need the sum per reference number. This is only a sample entry but the original is more than 1000 entry.

Attachment 262534

Thanks..

sAME FORMULA WILL WORK HERE YOU JUST NEED TO DO IT AS ATTACHED

IF SATISFIED CLICK"*" AND MARK THREAD AS SOLVED

[elaine6985]

Hi! Thank you very very much!! You helped me a lot! It will make my work more easier..
Take care & God Bless!

[DJGO]

Please try this file.

Hi would like to have follow up question, how'd u sort the ref & price column u did using formulas?