Thread: Formula help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Formula help

Use SUMIF, like this:

=SUMIF(A:A,146)

if your numbers are in column A.

Hope this helps.

Pete

On Nov 1, 2:41*am, mSWO wrote:
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?