Thread: Count to find the number of 100% 90% 80% in a column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Count to find the number of 100% 90% 80% in a column
.. to count the number of 100%
Did you try something like this:
=COUNTIF(Sheet2!3:3,100%)
or
=COUNTIF(Sheet2!A:A,100%)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"% Count" wrote:
I've tried different count functions but can't seem to get it right. I'm
trying to count the number of 100% on 1 line from a column on another sheet
and the 90%'s on another, 80% ..... The column I'm getting the 100% from is
a formula cell that returns this %. Could I please get help with this
formula.
Reply With QuoteReply With Quote