Thread
:
percentage negative values in column
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
percentage negative values in column
To answer your question:
Can anyone spot what I've done wrong ?
Remove the quotations marks around the second A2 in your fromula.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Graham" wrote in message
...
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
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann