Excel 2000 - problem with a Sum If (I think)
Mike
Thank you for seeing beyond my explanation! - your sumproduct function
worked perfectly - thank you so much and appologies to both for not
explaining the problem fully initially.
What a fab service this is.
"Mike H" wrote:
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.
|