| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 formula question
I would like to add up all the data in a row excluding any entry that is in
the minus. Is this possible? Nick |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 formula question
=SUMIF([row],"0")
Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Nick Wakeham" wrote: I would like to add up all the data in a row excluding any entry that is in the minus. Is this possible? Nick |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 formula question
One way:
=SUMIF(1:1, "0") In article , "Nick Wakeham" wrote: I would like to add up all the data in a row excluding any entry that is in the minus. Is this possible? Nick |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 formula question
Thanks - had a blank out for a minute - much appreciated
Nick "JE McGimpsey" wrote in message ... One way: =SUMIF(1:1, "0") In article , "Nick Wakeham" wrote: I would like to add up all the data in a row excluding any entry that is in the minus. Is this possible? Nick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 question - row and column limits | Excel Discussion (Misc queries) | |||
| Excel 2007 column chart fill question | Charts and Charting in Excel | |||
| Macro question in 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 Beta Charting Problem/Question | Charts and Charting in Excel | |||
| Another Filtering Question for Excel 2007 Experts | New Users to Excel | |||
Linear Mode
