IF or SUMIF for this one?

[goldilocks]

BP5 = the price of the items purchased
BQ5 = name of the vendor the items purchased from

BT5 & BU5 is merged column reserved for the said vendor. its parted to 'QTY' column and 'price'
How do i make the quantity of items purchased appear in BT5?

Please, your help will be very much appreciated. thx

[dilipandey]

Hi goldilocks,

Welcome to the forum.

Would suggest you to try and always avoid merging of cells on Excel sheet and for this query, please upload a sample workbook. thanks.


Regards,
DILIPandey

<click on below 'star' if this helps>