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
summing help please (2003 SP3)
-
- SilverLounger
- Posts: 1952
- Joined: 26 Jan 2010, 12:46
- Location: Nr. Heathrow Airport
summing help please (2003 SP3)
Steve
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin
-
- 5StarLounger
- Posts: 817
- Joined: 24 Jan 2010, 15:56
Re: summing help please (2003 SP3)
I think you want:
=SUMIF($B$4:$B$71,"PackageA",D$4:D$71)
=SUMIF($B$4:$B$71,"PackageA",D$4:D$71)
Regards,
Rory
Rory
-
- SilverLounger
- Posts: 1952
- Joined: 26 Jan 2010, 12:46
- Location: Nr. Heathrow Airport
Re: summing help please (2003 SP3)
Cheers Rory
That milkman sure produced a fine looking kid
Thats a big growth spurt since the last pic in "The other Place"
That milkman sure produced a fine looking kid
Thats a big growth spurt since the last pic in "The other Place"
Steve
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin
-
- 5StarLounger
- Posts: 817
- Joined: 24 Jan 2010, 15:56
Re: summing help please (2003 SP3)
I'm pretty sure it was the postman - the milkman doesn't have red hair... :)
Regards,
Rory
Rory
-
- SilverLounger
- Posts: 1952
- Joined: 26 Jan 2010, 12:46
- Location: Nr. Heathrow Airport
Re: summing help please (2003 SP3)
Hi Roryrory wrote:I think you want:
=SUMIF($B$4:$B$71,"PackageA",D$4:D$71)
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
You do not have the required permissions to view the files attached to this post.
Steve
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin
-
- Administrator
- Posts: 78478
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: summing help please (2003 SP3)
I don't understand your spreadsheet, but does
=SUMIF($E$4:$E$71,$E72,H$4:H$71)
do what you want?
=SUMIF($E$4:$E$71,$E72,H$4:H$71)
do what you want?
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 817
- Joined: 24 Jan 2010, 15:56
Re: summing help please (2003 SP3)
It's not at all clear (to me anyway) what totals you actually want on that sample?
Regards,
Rory
Rory
-
- SilverLounger
- Posts: 1952
- Joined: 26 Jan 2010, 12:46
- Location: Nr. Heathrow Airport
Re: summing help please (2003 SP3)
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
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
Steve
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin
-
- 5StarLounger
- Posts: 817
- Joined: 24 Jan 2010, 15:56
Re: summing help please (2003 SP3)
H72: =SUMPRODUCT(--($E$4:$E$71=$E72),--($F$4:$F$71="PackageA"),H$4:H$71)
I think! :)
I think! :)
Regards,
Rory
Rory
-
- SilverLounger
- Posts: 1952
- Joined: 26 Jan 2010, 12:46
- Location: Nr. Heathrow Airport
Re: summing help please (Case Closed)
Thnak you very much indeed, that certainly seems to have hit the spot
Steve
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin