Hi
Is it possible to get Excel to look at more than one column in this?
At present my formula looks like this:
=SUMIF(A1:A2014,"Apples",T1:T2014)
Where T1:T2014 is a number so result would be
Apples 4
What I want is for it to look at column B as well so:
=SUMIF(A1:A2014,"Apples", and B1:b2014,"Pears", T1:T2014)
so result would be, if A=Apples and B=Pears, then add up the number in column T
but it doesn't like it - is it actually possible?
Thanks
Maria
Is it possible to get Excel to look at more than one column in this?
At present my formula looks like this:
=SUMIF(A1:A2014,"Apples",T1:T2014)
Where T1:T2014 is a number so result would be
Apples 4
What I want is for it to look at column B as well so:
=SUMIF(A1:A2014,"Apples", and B1:b2014,"Pears", T1:T2014)
so result would be, if A=Apples and B=Pears, then add up the number in column T
but it doesn't like it - is it actually possible?
Thanks
Maria