#### Unlucky-Phase

##### New Member

- Joined
- Sep 23, 2019

- Messages
- 14

I'm wondering if it's possible to add a multiplier to COUNTIFS. I have a list of items, with a quantity, that are only purchased on certain weeks. I need to only count if it's checked on that week, and then when it is, multiple by the number in that column. I can do the COUNTIF okay but not sure on the multiplier.

This is my formula =COUNTIFS(C3:C7, "YES", A3:A7, "Apple")

C being the dates, A being the Item and B is the quantity. How do I get the COUNTIF to multiple the number returned ?

Thanks