Thread: countif = to
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ComoAdam ComoAdam is offline
external usenet poster
 
Posts: 1
Default countif = to

I have a sheet with name in column A and values in column B. Every 4 rows it
repeats. Each 4 row seccion is a new day. EX
DAY 1
Tim 3
Jim 2
Dan 1
DAY 2
Tim 2
Jim 3
Dan 1
And so on and so on. My question is, I would like to count the # of days
Tim = 3 for a months time. Is the countif function my best option? And how
do I enter a range of cells so that it only counts Tim's #. IE
B2,B6,B10,... ?
Thanks in advance for any help