Excel Help with wildcard and sumproduct

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.
 

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
I don't think wildcards can be used with SUMPRODUCT unfortunately :( 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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top