Unlucky-Phase
New Member
- Joined
- Sep 23, 2019
- Messages
- 14
Hello!
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
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