Thread: Countif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shu of AZ Shu of AZ is offline
external usenet poster
 
Posts: 130
Default Countif

This is a basic example of a problem I have run into.

I have one column, 10 rows deep. Each cell in the ten cells have the letter
X in it. I only want to count how many X's there are in the 1st,3rd,5th,7th
and 9th row. Countif requires a range I believe and does not allow seperate
multiple cells. Are there any other methods of doing this count.