| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
omit a negative number
Thanks!!!!
"Ron Coderre" wrote: Try something like this: A1: =SUMPRODUCT((MOD(COLUMN(A2:AD2),2)=1)*(A2:AD20)*A 2:AD2) That formula add the values from Row_2 in odd-numbered columns where the cell value is greater than zero. Is that something you can work with? *********** Regards, Ron XL2002, WinXP "LD6892" wrote: I have 30 columns and need to add every other column, but don't want to include the cell if it's a negative. =A2+C2+E2+G2, etc. Someone else designed the spreadsheet and I was hoping not to have to redo the whole thing to make it a sum formula. Thanks "Ron Coderre" wrote: How many range areas are you trying to sum? Are there only a few or many? Can you give an example of what you think the formula might look like? *********** Regards, Ron XL2002, WinXP "LD6892" wrote: How do I omit a cell that contains a negative number in an addition formula? I can't use sum because there are cells in between. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Negative Number to Postive number | Excel Worksheet Functions | |||
| cell to show ' 0 ' , or nothing at all, if the sum is a negative number | Excel Worksheet Functions | |||
| How to make the cell or font color red if the number is negative? | Excel Worksheet Functions | |||
| thousand separator as indian style for negative number | Excel Discussion (Misc queries) | |||
| 2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions | |||
Hybrid Mode
