Sorry I couldn't think of a more specific thread title. I think I need a remedial explanation about SUMIF because I can't fathom For SUMIF gurus:

A1="X+10*10"
B1
Note, B1 now shows
+10*10
However, use my A1 and B1; don't just type +10*10 in B1.

Type a 1 in A2. Hit the 1 key and enter key.
c
gives 0

A2=1
(type =1 in A2)
C1=SUMIF(A2:A2,">0",B1:B1)
gives 1
Why?

By the way, to save yourself a couple of typing strokes
C1=SUMIF(A2,">0",B1)
gives the same as
C1=SUMIF(A2:A2,">0",B1:B1)