Hello
I need help I have a column with 8 options, select with a pick list. I am trying to Calculate a percentage for each criteria.
Eg
Col A
Row 1 N/A
Row 2 Cut
Row 3 Sew
Row 4 Sew
Sew 67%
Cut 33%
The above Example shows that sew is 67% and cut 33%. I want to ignore the N/A so hence the formula should be countif(a1:a4, "Sew")/(4-1) ignoring the N/A. The above is a sample set of data the list can be up to 20 long.
Please help
Mo
Last edited by Mo2783; 06-02-2009 at 09:10 AM. Reason: Attach Sample File
You mean?
=COUNTIF(A1:A4,"Sew")/COUNTIF(A1:A4,"<>#N/A")
Remove the # sign if the N/A is not a result of an error
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
What i mean is i want to count the total in number of Sew selected in the column and then get a percentage of sew selected excluding anything that is "N/A"
I have attached a sample file.
Try the formula I gave you.. it results in 67%
Thanks for the Help the formula worked. I had to remove the "#" so the final formula was =COUNTIF(C7:C42,"Sew")/COUNTIF(C7:C42,"<>N/A")
No problem... but I did mention that option in my original post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks