CountIf formula - Counting entries by the day of the week

**IcemanFTW** · 03-03-2011, 12:42 PM

I currently working on creating a spreadsheet to help track my running. I'm a bit of a stats junkie so I like to break my runs down by day, week and month.

What I want to do is get a count of the number of times I run on each day.

In column A I have each day of the month listed and in column C I have the distance that I ran. What is the best way to go about getting the result I'm looking for?

I've tried using countif and I can't seem to get the results.

Thanks

**BeatBama** · 03-03-2011, 12:52 PM

that wheel may have already been invented

http://www.vertex42.com/ExcelTemplates/running-log.html

**NBVC** · 03-03-2011, 12:54 PM

Welcome to the forum,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST

**IcemanFTW** · 03-03-2011, 12:59 PM

Originally Posted by BeatBama

that wheel may have already been invented

http://www.vertex42.com/ExcelTemplates/running-log.html

I've looked at that spreadsheet, but it doesn't give me what I'm looking for, which is why I'm trying to create my own running log.

Thanks though!

**scottylad2** · 03-03-2011, 01:01 PM

In B35 and drag along
SUMPRODUCT(--($A2:$A32=B34),--($C2:$C32<>""))
This will give you a count of runs on each day

in B36 and drag along
SUMIF($A2:$A32,B34,$C2:$C32)
This will give you a sum of the miles for each day

**scottylad2** · 03-03-2011, 01:03 PM

Hadn't spotted your instruction from the Forum Moderator, remember to alter your posts title thread

**IcemanFTW** · 03-03-2011, 01:04 PM

Originally Posted by scottylad2

In B35 and drag along
SUMPRODUCT(--($A2:$A32=B34),--($C2:$C32<>""))
This will give you a count of runs on each day

in B36 and drag along
SUMIF($A2:$A32,B34,$C2:$C32)
This will give you a sum of the miles for each day

Thanks so much!