Summing non-adjacent lines

[Jeanie]

I have a spreadsheet that is set up as follows:

ID# Type A Type B Type C
1111111 Value 1 1 3 5
Value 2 $50.00 $25.00 $75.00
Value 3 3 5 7
2222222 Value 1 5 7 2
Value 2 $25.00 $75.00 $50.00
Value 3 7 2 4
3333333 Value 1 2 4 1
Value 2 $75.00 $50.00 $25.00
Value 3 4 1 3

There are over 10,000 IDs all within 35 different columns (types). At the bottom I want to have one total of all clients for value 1 in type a, type b, type c (and so on); one total of all clients for value 2 in type a, type b, type c (and so on); and one total for all clients for value 3 in type a, type b, type c (and so on).

Any help anyone can give would be appreciated.

Thx!

Jeanie

 

[Zathras]

You should be able to use the "SUMIF" formula. If your "values" are exactly as indicated, then the following formulas in column C (entered on rows below row 40,000 in this example):

C40001: =SUMIF($B$2:$B$40000,"Value 1",C$2:C$40000)
C40002: =SUMIF($B$2:$B$40000,"Value 2",C$2:C$40000)
C40003: =SUMIF($B$2:$B$40000,"Value 3",C$2:C$40000)

can be copied to columns D thru whatever to give you what you asked for.

 

[Jeanie]

Thanks - that worked wonderfully!!

Jeanie