ExcelBanter - Formula help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula help (https://www.excelbanter.com/excel-discussion-misc-queries/208629-formula-help.html)

mSWO

Formula help

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

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?

All times are GMT +1. The time now is 12:28 AM.