Issues with Sumif

[hammer1973]

Help.

Im having trouble with SUMIF. I am trying get a total for columm Q ranges Q8:Q1414 if the value of P is the text "Man Ltrs from IPS".

I tried the following formula:

Sumif(Q8:Q1414,"Man Ltrs from IPS",P8:P1414) and Sumif(P8:P1414,"Man Ltrs from IPS",Q8:Q1414) but i get a 0 result or value.

I've attached the spreasheet if anyone can help it would be appreiated, its on the Jubilee Inward Tab.

Cheers,

[AlexandraT]

You have an extra space before "Man" in the cells. So the actual text is, and should be " Man Ltrs from IPS". If you add the space it works. Alternatively, you can use this:

=SUMIF(P8:P1414,P1418,Q8:Q1414)

If you want to have no extra spaces, use TRIM() for P8 to P1414.

Alex

[hammer1973]

You have an extra space before "Man" in the cells. So the actual text is, and should be " Man Ltrs from IPS". If you add the space it works. Alternatively, you can use this:

=SUMIF(P8:P1414,P1418,Q8:Q1414)

If you want to have no extra spaces, use TRIM() for P8 to P1414.

Alex

School boy error, thanks.