| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to ignore negative numbers in a column?
I have a lengthy spreadsheet with several columns of numerical data. Some
cells have positive numbers and others have negative numbers. My goal is to get both a column sum and average--but only of only those cells with a positive number--i would like to exclude the negative numbers from my calculations. Are there formulas that will so this for me? -- Tia, Education and Documentation Specialist |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| formula for negative and positive numbers in different columns | Excel Worksheet Functions | |||
| How do I change a column of 500 numbers from positive to negative | Excel Discussion (Misc queries) | |||
| How do I change the plus to a negative in a column of numbers? | Excel Worksheet Functions | |||
| FORMULA TO ADD POSITIVE AND NEGATIVE NUMBERS, REGARDLESS OF SIGN | Excel Discussion (Misc queries) | |||
Threaded Mode
