I have banged my head against the wall for 3 hours now trying different functions. Mostly with SUMIF. While the cell will take the formula as a good formula, it will not calculate properly. It simply shows me the number in cell Q13.

=SUMIF(Q12,"1",Q13:Q16)

Also tried =SUMIF(Q12:Q12,"1",Q13:Q16)

and (just for grins) =SUMIF(Q13:Q16,"1",Q12:Q12)

and =SUMIF(Q13:Q16,"1",Q12)

I didn't expect the last two to work, but I ran out of things to try.

I tried a few iterations of COUNTIF and IF ISBLANK too.

Any thoughts?

Thanks.

P....