98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Percentage of column entry
Percentage of column entry
Resolved · High Priority · Version 2003
Wed 27 Aug 2008, 12:16Delegate Adele said...
Adele has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Percentage of column entry
Hello
I was hoping someone could help with a formula
In column A i have 8 rows
In column B i have 8 rows where some have entry some have not
I need the percentage of column B of the 8 rowns (A) basis which have entry or not in B rows
Can anyone help?
Tks
Adele
Fri 29 Aug 2008, 10:15Trainer Stephen said...
RE: Percentage of column entry
Hi Adele
Thank you for your question
You can nest 2 "counta" functions into a simple division calculation and then format the result as percentage.
The syntax is as follows
=COUNTA(Range of second row)/COUNTA(Range of first row)
The countA function counts how many non blank cells there are in a given range.
All you need to do is type the above into the cell where you want the result, taking care to put the correct ranges into the CountA functions
Hope this helps
Regards
Stephen
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Rotating Text in an Excel 2010 WorksheetMaybe you want to draw attention to certain text or you just simply want to make your worksheet look more exciting! |
