View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Thommo Thommo is offline
external usenet poster
 
Posts: 4
Default Sumproduct help please!

I have used sumproduct in the past but not with wildcards, not sure if it
possible..but..here is what I am trying to get:

Data table with Product and location joined and the a qty to sum eg in A1:
Sydney - Dry Starch 20
Sydney - Wet Starch 10
Sydney - Dry Gluten 20
Melbourne - Dry Starch 50
Melbourne - Wet Starch 10

My issue is that I want to sum the Site and General Product "*Starch"
"*Gluten"
to end up with in an area say F1, F2 etc
Sydney - *Starch = 30
Sydney - *Gluten = 20
Melbourne - *Starch = 60

I have each part of sumproduct working but not together.
Here is my attempt:
=Sumproduct(--(Match(A1:A5 = F1)),--(B1:B5))
I keep getting errors??