Question about Microsoft Office 2003 Basic Edition English (s55-00066) for PC
How do I finish this formula to beable to reflect the number of accurences in an array and then have the results be a percentage.
=COUNTIF(A3:A74,"1")
I am not sure but I was looking at this problem and I thought the equation should be reversed as I put it below. This gives a percetage of the entrys that are of the value 1 as it seems you are looking for.
=COUNTIF(A3:A74,"1")/COUNT(A3:A74)*100
Posted on Nov 28, 2008
Apply the following:
COUNT(A3:A74)/COUNTIF(A3:A74,"1")*100 in order to obtain the percentage.
Posted on Nov 26, 2008
Jan 19, 2016 | Business & Productivity Software
on Nov 11, 2013 | Microsoft Excel Business & Productivity...
Nov 17, 2011 | Microsoft Excel for PC
Jan 03, 2009 | Microsoft Business & Productivity Software
Dec 21, 2008 | Microsoft Excel for PC
Nov 13, 2008 | Business & Productivity Software
Sep 30, 2008 | Microsoft Excel for PC
Aug 08, 2008 | Microsoft Excel for PC
Mar 25, 2008 | Microsoft Excel for PC
Nov 19, 2007 | Business & Productivity Software
131 people viewed this question
Usually answered in minutes!
×