summing help please (2003 SP3)

[steveh]

Good afternoon

I have a spread sheet that has

Column A = a product code of A, B or C
Column B = A fee type, for example PackageA, PackageD or C&DD
Columns D-N = months

I need to sum at the bottom for each of the products so I have a row for PackageA, PackageD etc. So my visualisation is (wronhgly of course), for PackageA in the Jan column

=Match(A4:A71,B4:B71,"PackageA",SUM(D4:D71) ??

As usual the 7th Cavalry most appreciated

[rory]

I think you want:
=SUMIF($B$4:$B$71,"PackageA",D$4:D$71)

[steveh]

Cheers Rory

That milkman sure produced a fine looking kid

Thats a big growth spurt since the last pic in "The other Place"

[rory]

I'm pretty sure it was the postman - the milkman doesn't have red hair... :)

[steveh]

I think you want:
=SUMIF($B$4:$B$71,"PackageA",D$4:D$71)

Hi Rory

That is missing the the A, B or C that is (was) in column A

I have attached a small samle if you would not mind taking a look

[HansV]

I don't understand your spreadsheet, but does

=SUMIF($E$4:$E$71,$E72,H$4:H$71)

do what you want?

[rory]

It's not at all clear (to me anyway) what totals you actually want on that sample?

[steveh]

Thanks Rory and Hans

In for example H72 I would like to look up all of the incidences of A in column E, Match it with all incidences of PackageA in Column F and then sum any values that are in (January)H4:H71
In H73 the same thing but matching Column E with the letter B and column F with PackageA

Hope that makes it a bit clearer

[rory]

H72: =SUMPRODUCT(--($E$4:$E$71=$E72),--($F$4:$F$71="PackageA"),H$4:H$71)
I think! :)

[steveh]

Thnak you very much indeed, that certainly seems to have hit the spot