On second thoughts perhaps you mean

=IF(A5=5,SUM(B:B),"A5 isn't 5 so I'm not going to sum column B")

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.