Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
Sumproduct | Excel Discussion (Misc queries) | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct help | Excel Worksheet Functions |