LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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??
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional SUMPRODUCT or SUMPRODUCT with Filters Ted M H Excel Worksheet Functions 4 August 14th 08 07:50 PM
Sumproduct bpeltzer Excel Discussion (Misc queries) 1 April 30th 08 06:56 PM
sumproduct? sumif(sumproduct)? David Excel Worksheet Functions 3 July 13th 07 07:06 PM
Sumproduct ceemo Excel Worksheet Functions 3 February 28th 06 09:15 PM
sumproduct help JR Excel Worksheet Functions 0 February 27th 06 02:57 PM


All times are GMT +1. The time now is 06:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"