why doesnt this work

[chazzerman01]

why does this formula not work it just comes out as 0

 

[jmacleary]

Hi there. Are you expecting it to add up those rows that have a zero as the last digit? i.e. rows 3,6,10,11,12,14 and 15. If so, you will need to have the numbers converted to text in a helper column first. Use the formula =TEXT(E2,0) in (say) column I, and then use that column for the range, so your formula becomes =SUMIF(I2:I22,"*0",F3:F22)

 

[Peter_SSs]

why does this formula not work

Because column E is numerical and your comparison "*0" is text.

Try sumproduct instead
=SUMPRODUCT(--(RIGHT(E2:E22,1)="0"),F2:F22)

 

[jmacleary]

Oooh, Peter, your solution is good - I wasn't thinking straight or I'd have gone that way too.

 

[chazzerman01]

that's worked perfectly thank you

 

[Peter_SSs]

that's worked perfectly thank you

You're welcome. Thanks for the confirmation.

BTW, for the future, you will get much better response if you show data that can be copied, rather than just an image from which helpers would have to manually type the data to test. My signature block below has help with that.