Formula help

M

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?
 
P

Pete_UK

Use SUMIF, like this:

=SUMIF(A:A,146)

if your numbers are in column A.

Hope this helps.

Pete
 
Top