Perhaps

=SUM(INDIRECT("B1" & ":" & "B" & A5))

Changing the value of A5 will change the number of rows summed.

Mike

"Scoobs" wrote:

Hello
Can anyone please help me.
I am trying to create a function that will sum up a column of numbers if
another cell in another column equals a particular value.

I have 2 columns with values in them - e.g.

A1 Column A Column B
A2 1 10
A3 2 20
A4 3 30
A5 4 40
etc.

example:
if A5 = 4, then add up all in coumn B

I have tried numerous things and nothing seems to work.

I would be grateful for any help that can be given.