Thread: Using COUNTIF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
jack jack is offline
external usenet poster
 
Posts: 186
Default Using COUNTIF

I have a range of number between 1 and 5. Four of the cells in the range
display formulas. The formulas I am using to determine the number of 1's,
2's, 3's, etc a COUNTIF(A1:A233,"1");..... COUNTIF(A1:A233,"5"). How do
I get the COUNTIF formulas to count the cells containing the formulas?