which function will do this?
 

Is there a function which provides the sum of the values in column B that
correspond to a specified value in column A.
eg

A B
1 2
1 3
2 0
3 0
4 5
4 5
4 5

1 would return 5, 2 and 3 would return 0 and 4 would return 15

ta

which function will do this?
 

On Mon, 18 Feb 2008 09:40:03 -0800, fikko
wrote:

Is there a function which provides the sum of the values in column B that
correspond to a specified value in column A.
eg

A B
1 2
1 3
2 0
3 0
4 5
4 5
4 5

1 would return 5, 2 and 3 would return 0 and 4 would return 15

ta


SUMIF
--ron

which function will do this?
 

=SUMPRODUCT(--(A1:A7=4),--(B1:B7))
for items in column A with a 4
--
Gary''s Student - gsnu200769


"fikko" wrote:

Is there a function which provides the sum of the values in column B that
correspond to a specified value in column A.
eg

A B
1 2
1 3
2 0
3 0
4 5
4 5
4 5

1 would return 5, 2 and 3 would return 0 and 4 would return 15

ta