SUMIF Only PENCIL

Hello.

I want to calculate only the sum of products that contain the word “PENCIL”.
Apparently, my formula is wrong!

Would you please help me?
Thank you.
PRICE.ods (17.3 KB)

Please try this
Options

4 Likes

And extend the ranges to row 14

2 Likes