- Joined
- Aug 26, 2016
- Messages
- 1
- Reaction score
- 0
Hello everyone, I really need your Help , I'm trying to do a Wild card in this formula.
=SUMPRODUCT($G$2:$G$19,$H$2:$H$19*($E$2:$E$19=$K15))
Wild card that can be used with a sumproduct ?
Your help would be greatly appreciated.
=SUMPRODUCT($G$2:$G$19,$H$2:$H$19*($E$2:$E$19=$K15))
Wild card that can be used with a sumproduct ?
Your help would be greatly appreciated.
You can use them with SUMIF and SUMIFS though (plus others), would any of those be of use with what you are looking to do?