Please help me with a formula!

[underexaggeration]

[FONT=&quot]Simplified version so it makes sense. [/FONT]

[FONT=&quot]I have two columns of data. In the first is a series of numbers. In the second is a series of numbers (all integers between 1 and 10) that is generated independantly of the first. [/FONT]

[FONT=&quot]At the bottom of the first column, I want a formula that only sums the values of the column which correspond to a value n in the same row of the second column. [/FONT]

[FONT=&quot]Example [/FONT]
[FONT=&quot]1 5 [/FONT]
[FONT=&quot]5 6 [/FONT]
[FONT=&quot]4 5 [/FONT]
[FONT=&quot]3 7 [/FONT]
[FONT=&quot]1 0 [/FONT]
[FONT=&quot]5 9 [/FONT]
[FONT=&quot]9 8 [/FONT]
[FONT=&quot]8 5 [/FONT]
[FONT=&quot]If n=5, the the formula would output 1+4+8=13, as 1,4 and 8 are the only values in column 1 which correspond to a 5 in column 2. [/FONT]

[FONT=&quot]Thanks everyone! If the answer is "Can't be done!" please let me know so I don't waste any time.[/FONT]

 

[Ranitha]

=sumif(b5:b12,5,a5:a12)

 

[Fishboy]

Simplified version so it makes sense.

I have two columns of data. In the first is a series of numbers. In the second is a series of numbers (all integers between 1 and 10) that is generated independantly of the first.

At the bottom of the first column, I want a formula that only sums the values of the column which correspond to a value n in the same row of the second column.

Example
1 5
5 6
4 5
3 7
1 0
5 9
9 8
8 5
If n=5, the the formula would output 1+4+8=13, as 1,4 and 8 are the only values in column 1 which correspond to a 5 in column 2.

Thanks everyone! If the answer is "Can't be done!" please let me know so I don't waste any time.

Hi underexaggeration, welcome to the boards.

If I have understood correctly you want to sum the values in column A where the values in column B meet your criteria? If so then is it not just:

=SUMIF(B1:B8,5,A1:A8)

If you had a cell somewhere containing your desired n value (lets say D1 for the sake of argument) then you could write the formula as:

=SUMIF(B1:B8,D1,A1:A8)

 

[oldbrewer]

1	5		row 12
5	6
4	5
3	7
1	0
5	9
9	8
8	5
col A	col B			select a number	5	<<<<g22< td=""></g22<>	G22
				13
				=SUMPRODUCT(($B$12:$B$19=$G$22)*($A$12:$A$19))

<tbody>
</tbody>

 

[underexaggeration]

Thank you all so much!

 

[Fishboy]

Thank you all so much!

Happy to help