| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate only Positive Numbers
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 -- B G |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate only Positive Numbers
If you summing them:
=SUMIF(AL3:AL1359,"0") HTH "B G" wrote: 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 -- B G |
|
#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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate only Positive Numbers
sumif(al3:al1359,"0",al3:al1359) Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=554967 |
| Reply |
| 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 | |||
Hybrid Mode
