Formula help

[mSWO]

Spreadsheet cell contains one of two possible options (144 or 146)

How do I sum the total number of 146's in the column in a formula?

 

[Pete_UK]

Use SUMIF, like this:

=SUMIF(A:A,146)

if your numbers are in column A.

Hope this helps.

Pete