Excel Help with wildcard and sumproduct

5

539Nelson Calix

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.
 
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

Excel Countifs/Sumproduct with mutil Or statement 3
Scrabble Value calculation for Welsh words 0
Excel sum if and closed workbooks 2
Excel Subtracting multiple columns from another column 3
Wildcard not working in SumProduct Array 8
Access General Date Forced To Have Date And Time 2
Sumproduct 3
Excel Sumproduct 0

Back
Top