| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
percentage negative values in column
Hi, I want to calculate the % of negative values in a column, using a dynamic
range. i.e No. of negative values, divided by total number of values, X100, to give a %. The following formula works, but is returning the wrong value: =SUM(COUNTIF(INDIRECT("$C$13:C"&A2),"<0")/(COUNT(INDIRECT("$C$13:C"&"A2")))*100) Can anyone spot what I've done wrong ? and/or a simpler way of doing the same thing ? Many Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I format a column to show a negative percentage in red? | Excel Discussion (Misc queries) | |||
| how do i sum up a column of time values but ignore negative values | New Users to Excel | |||
| how do i set up a column with negative values automatically? | Excel Discussion (Misc queries) | |||
| increase all values in a column by a percentage | Excel Worksheet Functions | |||
| Stacked column, 2 values, percentage? | Charts and Charting in Excel | |||
Threaded Mode
