countif = to

C

ComoAdam

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top