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
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
