| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate only Positive Numbers
Nel post
*B G* ha scritto: I need to know if there is a way to calculate only cells within a column (column AL) that are a positive number. The column has rows 3 through 1359 with quite a few that are negative numbers (these numbers are a result of a formula) WE only want to include in the column total those numbers that have a positive result. Is this possible? THanks =SUMIF(AL3:AL1359,"0") -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions | |||
| How to change a series of positive numbers to negative numbers | Excel Worksheet Functions | |||
| average positive numbers | Excel Discussion (Misc queries) | |||
| Negative numbers turn positive automatically on data entry | Excel Discussion (Misc queries) | |||
| Formula to calculate only the negative numbers | Excel Worksheet Functions | |||
Threaded Mode
