Adding just positive numbers

[Raggy]

cells AL112:AP112 contain a formula i.e. =AL77-AL46 and so on, I want to add a total of only the positive numbers that appear
using the formula =SUMIF(AL112:AP112,"">0) in AQ112 does not seem to work, presume I need to tell it somehow what the cell value is as at the min it just gives 0 as an answer.

 

[steve the fish]

You need ">0" not "">0

 

[Michael M]

Try

=SUMIF(AL112:AP112,">"&0)

 

[Raggy]

Doh! Why did I not spot that! Looked at it long enough! Thanks.