Question about Microsoft Office 2003 Basic Edition English (s55-00066) for PC
I need to count all fields in a column with an entry, deduct those with an "x" or other symbol, then divide by total fields with an entry, multiply by 100 to get %.
You should use the formula COUNT (Cell1, Cell2), please replace Cell1 and Cell2 for the range of your cells in Excell. You could use too the formula COUNT.IF(Cell1,Cell2,Criterion), Cell1 and Cell2 is the range of cells when can exist an entry.
Example The final formula is like:
Posted on Nov 24, 2008
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
Jan 19, 2016 | Computers & Internet
Mar 24, 2011 | Computers & Internet
Apr 18, 2009 | Microsoft Excel for PC
Dec 21, 2008 | Microsoft Excel for PC
Apr 09, 2008 | Microsoft Excel for PC
Feb 05, 2008 | Microsoft Excel for PC
Dec 17, 2007 | Computers & Internet
107 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: