Re: Sum data together based on Header Product Description

From: Andy B (andy)
Date: 07/15/04 

Date: Thu, 15 Jul 2004 16:56:41 +0100

Hi

Try something like this:
=SUMPRODUCT((ISNUMBER(FIND("Apples",$B$2:$CB$2)))*(B3:CB3))
This will sum the range B3:CB3 where there is Apples in the row above. You
can change the "Apples" to the cell ref of your heading. 

-- 
Andy.
"Jay" <Jay@discussions.microsoft.com> wrote in message
news:E2BFEE0C-EF53-40D8-815E-8489B9F32A57@microsoft.com...
> I have this a Excel application that is used for tracking various
products. This is done via a series of column headers across the top of a
section range say: B2:CB2
> Blood Oranges, Asian Pears, Boch Pears, Anjou Pears, Lemons, Limes, Navel
Oranges, Red Delicious Apples, Golden Delicious Apples, Florida Oranges,
etc,etc.
>
> Vertically the values were related to the various aspects of the product
example below:
> Box Quantity Range B3:CB3
> Quantity Per Box Range B4:CB4
> Bad Product Range B5:CB5
> Box Weight Range B6:CB6
> Product Returned Range B7:CB7
> Total Product Shipped Range B8:CB8
>
> Florida Oranges Red Delicious Apples Lemons Limes Anjou Pears Navel
Oranges Golden Delicious Apples Asian Pears Blood Oranges Boch Pears
> 26 27 20 25 29 26 27 20 25 29
> 43199 43199 13950 29249 43199 43199 43199 13950 29249 43199
> 0 4515 0 0 045 0 15 0 0 0
> 43199 38684 13950 29249 43199 43199 38684 13950 29249 43199
> 410 400 375 200 435 410 400 375 200 435
> 43199 38684 13950 29249 43199 43199 38684 13950 29249 43199
>
> Lower down the *** I have a section where all totals are grouped by
product type as follows:
>
> Apples      Pears      Lemons      Limes      Oranges
> 86398       100348    13950        29249      115647
> 4530          45            0                0              0
> 77368       100348    13950        29429      115647
> 800           1245        375            200          1020
> 77368       100348    43199        43199      115674
>
> I want to scan to Header section for Product name, then, sum these based
on product in lower section. Is this possible????
>
> Thanks,
>