MrMajinbuu
New Member
- Joined
- May 21, 2018
- Messages
- 8
- Office Version
- 365
- 2021
- Platform
- Windows
=SUMPRODUCT(($C$14:$C$29=$C$31)*$D$14:$D$29*E14:E29)
Thank you. It returned #Value! at first. But then i checked there is a cell with text and fixed that and the formula works perfectlyMay be:
Code:=SUMPRODUCT(($C$14:$C$29=$C$31)*$D$14:$D$29*E14:E29)