| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing minus numbers from a sumif
I am using the following countif formula in my spreadsheet
=SUMIF($B$3:$B$158,B167,$R$3:$R$158)/COUNTIF($B$3:$B$158,B167) However I would like my sumif to ignore minus values (or replace them with a 0), have you any ideas how this could be done? Thanks Nick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotaling minus negative numbers and posative numbers | Excel Worksheet Functions | |||
| Removing beginning minus sign from telephone numbers | Excel Discussion (Misc queries) | |||
| col of minus numbers changed to plus numbers | Excel Worksheet Functions | |||
| How do I change minus numbers to + numbers in a col in Excel? | Charts and Charting in Excel | |||
| Sum of a row minus two smallest numbers | Excel Worksheet Functions | |||
Threaded Mode
