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

Similar Threads

Remove Identical words 0
List all tables, including document structure 0
count if 1
Style Header Reformatted 3
Weigh tasks 0
Sumproduct in matrix means 3
Finding the weighted average of text that have been given values 1
If Hours >0, If Volume <= 0,(and vice-versa) then.... 4

Top