multiple countif's

T

traveler911

New Member
Joined
Apr 16, 2013
Messages
5
I am working on attmpting to count the number of times in the year that workout occur on each day of the week.

The data tab has lested all the days of the week (Sun, Mon, Tues Etc on column A), Colum B has the date, and the rest of the colums is the data related to the activity for that day.

What I need to do is count the number of time for the entire year that I run on Sunday, and then on Monday. I have competed a countif, but it does it for every Sunday, whereas I only want where real data occurs.

Thanks
Kent
[TABLE="width: 500"]
<tbody>[TR]
[TD]Sun
[/TD]
[TD]3/17
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mon
[/TD]
[TD]3/18
[/TD]
[TD]1
[/TD]
[TD]1.55
[/TD]
[TD]13:44
[/TD]
[TD]11:53
[/TD]
[TD]171
[/TD]
[/TR]
[TR]
[TD]Tue
[/TD]
[TD]3/19
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Wed
[/TD]
[TD]3/20
[/TD]
[TD]1
[/TD]
[TD]3.474
[/TD]
[TD]46:49
[/TD]
[TD]13:29
[/TD]
[TD]519
[/TD]
[/TR]
[TR]
[TD]Thu
[/TD]
[TD]3/21
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fri
[/TD]
[TD]3/22
[/TD]
[TD]1
[/TD]
[TD]3.149
[/TD]
[TD]41:01
[/TD]
[TD]13:02
[/TD]
[TD]441
[/TD]
[/TR]
[TR]
[TD]Sat
[/TD]
[TD]3/23
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Sort by date Sort by votes
traveler911 said:
I am working on attmpting to count the number of times in the year that workout occur on each day of the week.

The data tab has lested all the days of the week (Sun, Mon, Tues Etc on column A), Colum B has the date, and the rest of the colums is the data related to the activity for that day.

What I need to do is count the number of time for the entire year that I run on Sunday, and then on Monday. I have competed a countif, but it does it for every Sunday, whereas I only want where real data occurs.

Thanks
Kent
[TABLE="width: 500"]
<tbody>[TR]
[TD]Sun[/TD]
[TD]3/17[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mon[/TD]
[TD]3/18[/TD]
[TD]1[/TD]
[TD]1.55[/TD]
[TD]13:44[/TD]
[TD]11:53[/TD]
[TD]171[/TD]
[/TR]
[TR]
[TD]Tue[/TD]
[TD]3/19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Wed[/TD]
[TD]3/20[/TD]
[TD]1[/TD]
[TD]3.474[/TD]
[TD]46:49[/TD]
[TD]13:29[/TD]
[TD]519[/TD]
[/TR]
[TR]
[TD]Thu[/TD]
[TD]3/21[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fri[/TD]
[TD]3/22[/TD]
[TD]1[/TD]
[TD]3.149[/TD]
[TD]41:01[/TD]
[TD]13:02[/TD]
[TD]441[/TD]
[/TR]
[TR]
[TD]Sat[/TD]
[TD]3/23[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Click to expand...

Hello and welcome.
I can not see data for Sunday.
Which column is the workout?
 
Upvote 0
Columns D on are for the workout.
D is length of run
E is length of workout length
F is the split for the workout (Pace/mile)

This is a sample week, to express the problem. Some weeks I only workout three days, some more. What I need to do is only count the data for a given day WITH data. So this week, don't count Sunday, but do count Monday as it does have data.
 
Upvote 0
WorkoutsDistanceDurationCaloriesAVG DistanceAVG DurationAVG TimeAVG SpeedAVG Calories BurnedAVG Mile/Day
34165.49433:15:55 25,653.10 4.86700:58:4200:12:04#VALUE!754.500.02
5K#CountMilesAVG # MilesAVG Length
10K#Su4720.046#MACRO?00:00:00
13.1#Mo4833.03900:00:00
26.2#Tu4817.58300:00:00
We4636.66600:00:00
Th4618.1220
Fr4525.5360
Sa4614.5020
165.494

<colgroup><col width="78"><col width="70"><col width="67"><col width="59"><col width="75"><col width="64"><col width="64"><col width="60"><col width="52"><col width="62"><col width="66"></colgroup> <tbody>
[TD="width: 718, colspan: 11"] 2013 Running Log [/TD]

[TD="bgcolor: #FFFFFF"] January [/TD]
[TD="bgcolor: #FFFFFF"]4[/TD]
[TD="bgcolor: #FFFFFF"]12.667[/TD]
[TD="bgcolor: #FFFFFF"]02:40:59[/TD]
[TD="bgcolor: #FFFFFF"]2,098.2[/TD]
[TD="bgcolor: #FFFFFF"]3.167[/TD]
[TD="bgcolor: #FFFFFF"]00:40:15[/TD]
[TD="bgcolor: #FFFFFF"]00:12:43[/TD]
[TD="bgcolor: #FFFFFF"] #VALUE! [/TD]
[TD="bgcolor: #FFFFFF"]524.55[/TD]
[TD="bgcolor: #FFFFFF"]0.41[/TD]

[TD="bgcolor: #FFFFFF"] February [/TD]
[TD="bgcolor: #FFFFFF"]12[/TD]
[TD="bgcolor: #FFFFFF"]58.262[/TD]
[TD="bgcolor: #FFFFFF"]12:15:18[/TD]
[TD="bgcolor: #FFFFFF"]9,124.6[/TD]
[TD="bgcolor: #FFFFFF"]4.855[/TD]
[TD="bgcolor: #FFFFFF"]01:01:17[/TD]
[TD="bgcolor: #FFFFFF"]00:12:37[/TD]
[TD="bgcolor: #FFFFFF"] #VALUE! [/TD]
[TD="bgcolor: #FFFFFF"]760.38[/TD]
[TD="bgcolor: #FFFFFF"]2.08[/TD]

[TD="bgcolor: #FFFFFF"] March [/TD]
[TD="bgcolor: #FFFFFF"]13[/TD]
[TD="bgcolor: #FFFFFF"]67.060[/TD]
[TD="bgcolor: #FFFFFF"]13:08:57[/TD]
[TD="bgcolor: #FFFFFF"]10,213.5[/TD]
[TD="bgcolor: #FFFFFF"]5.158[/TD]
[TD="bgcolor: #FFFFFF"]01:00:41[/TD]
[TD="bgcolor: #FFFFFF"]00:11:46[/TD]
[TD="bgcolor: #FFFFFF"] #VALUE! [/TD]
[TD="bgcolor: #FFFFFF"]785.65[/TD]
[TD="bgcolor: #FFFFFF"]2.16[/TD]

[TD="bgcolor: #FFFFFF"] April [/TD]
[TD="bgcolor: #FFFFFF"]5[/TD]
[TD="bgcolor: #FFFFFF"]27.505[/TD]
[TD="bgcolor: #FFFFFF"]05:10:41[/TD]
[TD="bgcolor: #FFFFFF"]4,216.8[/TD]
[TD="bgcolor: #FFFFFF"]5.501[/TD]
[TD="bgcolor: #FFFFFF"]01:02:08[/TD]
[TD="bgcolor: #FFFFFF"]00:11:18[/TD]
[TD="bgcolor: #FFFFFF"] #VALUE! [/TD]
[TD="bgcolor: #FFFFFF"]843.36[/TD]
[TD="bgcolor: #FFFFFF"]0.92[/TD]

[TD="bgcolor: #FFFFFF"] May [/TD]
[TD="bgcolor: #FFFFFF"] 0 [/TD]
[TD="bgcolor: #FFFFFF"] 0.000 [/TD]
[TD="bgcolor: #FFFFFF"] 00:00:00 [/TD]
[TD="bgcolor: #FFFFFF"] 0.0 [/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#VALUE![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]0.00[/TD]

[TD="bgcolor: #FFFFFF"] June [/TD]
[TD="bgcolor: #FFFFFF"] 0 [/TD]
[TD="bgcolor: #FFFFFF"] 0.000 [/TD]
[TD="bgcolor: #FFFFFF"] 00:00:00 [/TD]
[TD="bgcolor: #FFFFFF"] 0.0 [/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#VALUE![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]0.00[/TD]

[TD="bgcolor: #FFFFFF"] July [/TD]
[TD="bgcolor: #FFFFFF"] 0 [/TD]
[TD="bgcolor: #FFFFFF"] 0.000 [/TD]
[TD="bgcolor: #FFFFFF"] 00:00:00 [/TD]
[TD="bgcolor: #FFFFFF"] 0.0 [/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#VALUE![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]0.00[/TD]

[TD="bgcolor: #FFFFFF"] August [/TD]
[TD="bgcolor: #FFFFFF"] 0 [/TD]
[TD="bgcolor: #FFFFFF"] 0.000 [/TD]
[TD="bgcolor: #FFFFFF"] 00:00:00 [/TD]
[TD="bgcolor: #FFFFFF"] 0.0 [/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#VALUE![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]0.00[/TD]

[TD="bgcolor: #FFFFFF"] September [/TD]
[TD="bgcolor: #FFFFFF"] 0 [/TD]
[TD="bgcolor: #FFFFFF"] 0.000 [/TD]
[TD="bgcolor: #FFFFFF"] 00:00:00 [/TD]
[TD="bgcolor: #FFFFFF"] 0.0 [/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#VALUE![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]0.00[/TD]

[TD="bgcolor: #FFFFFF"] October [/TD]
[TD="bgcolor: #FFFFFF"] 0 [/TD]
[TD="bgcolor: #FFFFFF"] 0.000 [/TD]
[TD="bgcolor: #FFFFFF"] 00:00:00 [/TD]
[TD="bgcolor: #FFFFFF"] 0.0 [/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#VALUE![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]0.00[/TD]

[TD="bgcolor: #FFFFFF"] November [/TD]
[TD="bgcolor: #FFFFFF"] 0 [/TD]
[TD="bgcolor: #FFFFFF"] 0.000 [/TD]
[TD="bgcolor: #FFFFFF"] 00:00:00 [/TD]
[TD="bgcolor: #FFFFFF"] 0.0 [/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#VALUE![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]0.00[/TD]

[TD="bgcolor: #FFFFFF"] December [/TD]
[TD="bgcolor: #FFFFFF"] 0 [/TD]
[TD="bgcolor: #FFFFFF"] 0.000 [/TD]
[TD="bgcolor: #FFFFFF"] 00:00:00 [/TD]
[TD="bgcolor: #FFFFFF"] 0.0 [/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#VALUE![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]0.00[/TD]

[TD="bgcolor: #000000"] Total [/TD]

[TD="colspan: 12"] 4/16/2013 12:24 [/TD]

</tbody>
It is currently showing the total number of Sunday's in the year instead of the only the number that I actually worked out. Hopefully once I get that, I then can finish out the table with AVG # miles ran on that day, and AVG Length of run on that day.
 
Upvote 0
traveler911 said:
WorkoutsDistanceDurationCaloriesAVG DistanceAVG DurationAVG TimeAVG SpeedAVG Calories BurnedAVG Mile/Day
34165.49433:15:55 25,653.10 4.86700:58:4200:12:04#VALUE!754.500.02
5K#CountMilesAVG # MilesAVG Length
10K#Su4720.046#MACRO?00:00:00
13.1#Mo4833.03900:00:00
26.2#Tu4817.58300:00:00
We4636.66600:00:00
Th4618.1220
Fr4525.5360
Sa4614.5020
165.494

<tbody>
[TD="colspan: 11"] 2013 Running Log [/TD]

[TD="bgcolor: #FFFFFF"] January [/TD]
[TD="bgcolor: #FFFFFF"]4[/TD]
[TD="bgcolor: #FFFFFF"]12.667[/TD]
[TD="bgcolor: #FFFFFF"]02:40:59[/TD]
[TD="bgcolor: #FFFFFF"]2,098.2[/TD]
[TD="bgcolor: #FFFFFF"]3.167[/TD]
[TD="bgcolor: #FFFFFF"]00:40:15[/TD]
[TD="bgcolor: #FFFFFF"]00:12:43[/TD]
[TD="bgcolor: #FFFFFF"] #VALUE! [/TD]
[TD="bgcolor: #FFFFFF"]524.55[/TD]
[TD="bgcolor: #FFFFFF"]0.41[/TD]

[TD="bgcolor: #FFFFFF"] February [/TD]
[TD="bgcolor: #FFFFFF"]12[/TD]
[TD="bgcolor: #FFFFFF"]58.262[/TD]
[TD="bgcolor: #FFFFFF"]12:15:18[/TD]
[TD="bgcolor: #FFFFFF"]9,124.6[/TD]
[TD="bgcolor: #FFFFFF"]4.855[/TD]
[TD="bgcolor: #FFFFFF"]01:01:17[/TD]
[TD="bgcolor: #FFFFFF"]00:12:37[/TD]
[TD="bgcolor: #FFFFFF"] #VALUE! [/TD]
[TD="bgcolor: #FFFFFF"]760.38[/TD]
[TD="bgcolor: #FFFFFF"]2.08[/TD]

[TD="bgcolor: #FFFFFF"] March [/TD]
[TD="bgcolor: #FFFFFF"]13[/TD]
[TD="bgcolor: #FFFFFF"]67.060[/TD]
[TD="bgcolor: #FFFFFF"]13:08:57[/TD]
[TD="bgcolor: #FFFFFF"]10,213.5[/TD]
[TD="bgcolor: #FFFFFF"]5.158[/TD]
[TD="bgcolor: #FFFFFF"]01:00:41[/TD]
[TD="bgcolor: #FFFFFF"]00:11:46[/TD]
[TD="bgcolor: #FFFFFF"] #VALUE! [/TD]
[TD="bgcolor: #FFFFFF"]785.65[/TD]
[TD="bgcolor: #FFFFFF"]2.16[/TD]

[TD="bgcolor: #FFFFFF"] April [/TD]
[TD="bgcolor: #FFFFFF"]5[/TD]
[TD="bgcolor: #FFFFFF"]27.505[/TD]
[TD="bgcolor: #FFFFFF"]05:10:41[/TD]
[TD="bgcolor: #FFFFFF"]4,216.8[/TD]
[TD="bgcolor: #FFFFFF"]5.501[/TD]
[TD="bgcolor: #FFFFFF"]01:02:08[/TD]
[TD="bgcolor: #FFFFFF"]00:11:18[/TD]
[TD="bgcolor: #FFFFFF"] #VALUE! [/TD]
[TD="bgcolor: #FFFFFF"]843.36[/TD]
[TD="bgcolor: #FFFFFF"]0.92[/TD]

[TD="bgcolor: #FFFFFF"] May [/TD]
[TD="bgcolor: #FFFFFF"] 0 [/TD]
[TD="bgcolor: #FFFFFF"] 0.000 [/TD]
[TD="bgcolor: #FFFFFF"] 00:00:00 [/TD]
[TD="bgcolor: #FFFFFF"] 0.0 [/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#VALUE![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]0.00[/TD]

[TD="bgcolor: #FFFFFF"] June [/TD]
[TD="bgcolor: #FFFFFF"] 0 [/TD]
[TD="bgcolor: #FFFFFF"] 0.000 [/TD]
[TD="bgcolor: #FFFFFF"] 00:00:00 [/TD]
[TD="bgcolor: #FFFFFF"] 0.0 [/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#VALUE![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]0.00[/TD]

[TD="bgcolor: #FFFFFF"] July [/TD]
[TD="bgcolor: #FFFFFF"] 0 [/TD]
[TD="bgcolor: #FFFFFF"] 0.000 [/TD]
[TD="bgcolor: #FFFFFF"] 00:00:00 [/TD]
[TD="bgcolor: #FFFFFF"] 0.0 [/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#VALUE![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]0.00[/TD]

[TD="bgcolor: #FFFFFF"] August [/TD]
[TD="bgcolor: #FFFFFF"] 0 [/TD]
[TD="bgcolor: #FFFFFF"] 0.000 [/TD]
[TD="bgcolor: #FFFFFF"] 00:00:00 [/TD]
[TD="bgcolor: #FFFFFF"] 0.0 [/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#VALUE![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]0.00[/TD]

[TD="bgcolor: #FFFFFF"] September [/TD]
[TD="bgcolor: #FFFFFF"] 0 [/TD]
[TD="bgcolor: #FFFFFF"] 0.000 [/TD]
[TD="bgcolor: #FFFFFF"] 00:00:00 [/TD]
[TD="bgcolor: #FFFFFF"] 0.0 [/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#VALUE![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]0.00[/TD]

[TD="bgcolor: #FFFFFF"] October [/TD]
[TD="bgcolor: #FFFFFF"] 0 [/TD]
[TD="bgcolor: #FFFFFF"] 0.000 [/TD]
[TD="bgcolor: #FFFFFF"] 00:00:00 [/TD]
[TD="bgcolor: #FFFFFF"] 0.0 [/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#VALUE![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]0.00[/TD]

[TD="bgcolor: #FFFFFF"] November [/TD]
[TD="bgcolor: #FFFFFF"] 0 [/TD]
[TD="bgcolor: #FFFFFF"] 0.000 [/TD]
[TD="bgcolor: #FFFFFF"] 00:00:00 [/TD]
[TD="bgcolor: #FFFFFF"] 0.0 [/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#VALUE![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]0.00[/TD]

[TD="bgcolor: #FFFFFF"] December [/TD]
[TD="bgcolor: #FFFFFF"] 0 [/TD]
[TD="bgcolor: #FFFFFF"] 0.000 [/TD]
[TD="bgcolor: #FFFFFF"] 00:00:00 [/TD]
[TD="bgcolor: #FFFFFF"] 0.0 [/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]#VALUE![/TD]
[TD="bgcolor: #FFFFFF"]#DIV/0![/TD]
[TD="bgcolor: #FFFFFF"]0.00[/TD]

[TD="bgcolor: #000000"] Total [/TD]

[TD="colspan: 12"] 4/16/2013 12:24 [/TD]

</tbody>
It is currently showing the total number of Sunday's in the year instead of the only the number that I actually worked out. Hopefully once I get that, I then can finish out the table with AVG # miles ran on that day, and AVG Length of run on that day.
Click to expand...

I can not see any Sunday's in the top table.
If you need our help please provide related data with desired outcome.
 
Upvote 0
What is your current formula for counting all sunday's and then we can work with that to modify to include only workout days.

Will there be days where you run only and do not work out or are there days where you workout only and not run? I'm just trying to figure out if we can hone in on one column for counting if a workout/run existed for that day or if we need to look at both columns?
 
Upvote 0
This is an approach you can probably adapt:
Excel Workbook
ABCDEFG
2Sun3/17/2013
3Mon3/18/201311.5513:4411:53171
4Tue3/19/2013
5Wed3/20/201313.47446:49:0013:29519
6Thu3/21/2013
7Fri3/22/201313.14941:01:0013:02441
8Sat3/23/2013
9Sun3/24/2013
10Mon3/25/2013
11Tue3/26/2013
12Wed3/27/2013
13Thu3/28/2013
14Fri3/29/2013
15Sat3/30/2013
16Sun3/31/2013
17
18
19
20Sun0
21Mon1
22Tue0
23Wed1
24Thu0
25Fri1
26Sat0
Sheet1
Cell Formulas
RangeFormula
A2=TEXT(B2,"ddd")
#VALUE!
 
Upvote 0
=COUNTIF($'2013-Workout'.A4:A331;$'Main Screen'.H22) H22 is Su on the table where I22 shows 47, and so forth.

The main objective is keeping track of all the data related to runs. There is concern that I am not staggering my day enough. So I need to show that each day of the week is getting adequate mileage in.
The table above is "Main Screen", and below is a small portion of the data table. It starts in January and goes all the way to December.

I'm working on my wife's computer right now, which is running Open Office, I was unable to use the array suggested below, or it just did not work.


One other question, is there an formula for counting number of days passed from now(). On the Main Screen --- Total line is the Average number of days ran in the year. It show's 0.2 as it is dividing out the entire year, and now only the section that has passed.

Su3/31n4.03900:45:0300:11:09590.05.385.05.82.53.0Train - 8 Mile26.2
Tu4/2o#DIV/0!Train - 4 Mile
Th4/4n3.10400:36:1000:11:39545.805.154.85.52.55.5Train - 4 Mile
Su4/7n5.39401:01:3000:11:24960.05.264.85.72.55.5Train - 5 Mile21.6
Tu4/9o#DIV/0!Train - 3 Mile
Th4/11o#DIV/0!110
Su4/14o#DIV/0!rest day3.0
Tu4/16o3.00800:35:3100:11:48437.05.085
Th4/18o#DIV/0!#DIV/0!1

<colgroup><col width="29"><col width="40"><col width="24"><col width="56"><col width="58"><col width="59"><col width="54"><col width="36"><col width="26"><col width="27"><col width="25"><col width="26"><col width="35"><col width="87"><col width="175"><col width="20"></colgroup> <tbody>
[TD="width: 29, bgcolor: #CCCCCC"]Fr[/TD]
[TD="width: 40, bgcolor: #CCCCCC"]3/29[/TD]
[TD="width: 24, bgcolor: #CCCCCC"] n [/TD]
[TD="width: 56, bgcolor: #CCCCCC"]5.240[/TD]
[TD="width: 58, bgcolor: #CCCCCC"]01:01:20[/TD]
[TD="width: 59, bgcolor: #CCCCCC"]00:11:42[/TD]
[TD="width: 54, bgcolor: #CCCCCC"]760.0[/TD]
[TD="width: 36, bgcolor: #CCCCCC"]5.13[/TD]
[TD="width: 26, bgcolor: #CCCCCC"]4.6[/TD]
[TD="width: 27, bgcolor: #CCCCCC"]6.0[/TD]
[TD="width: 25, bgcolor: #CCCCCC"]2.0[/TD]
[TD="width: 26, bgcolor: #CCCCCC"]2.5[/TD]
[TD="width: 35, bgcolor: #CCCCCC"]Home[/TD]
[TD="width: 87, bgcolor: #CCCCCC"]97[/TD]
[TD="width: 175, bgcolor: #33A3A3"][/TD]
[TD="width: 20"][/TD]

[TD="bgcolor: #FFCC99"]Sa[/TD]
[TD="bgcolor: #FFCC99"]3/30[/TD]
[TD="bgcolor: #FFCC99"] o [/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"]#DIV/0![/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"]Work[/TD]
[TD="bgcolor: #FFCC99"]Train - 5 Mile[/TD]
[TD="bgcolor: #33A3A3"][/TD]

[TD="bgcolor: #E6E6FF"]Home[/TD]

[TD="bgcolor: #33A3A3"][/TD]

[TD="bgcolor: #CCCCCC"]Mo[/TD]
[TD="bgcolor: #CCCCCC"]4/1[/TD]
[TD="bgcolor: #CCCCCC"] n [/TD]
[TD="bgcolor: #CCCCCC"]6.114[/TD]
[TD="bgcolor: #CCCCCC"]01:12:03[/TD]
[TD="bgcolor: #CCCCCC"]00:11:47[/TD]
[TD="bgcolor: #CCCCCC"]907.0[/TD]
[TD="bgcolor: #CCCCCC"]5.09[/TD]
[TD="bgcolor: #CCCCCC"]4.8[/TD]
[TD="bgcolor: #CCCCCC"]5.3[/TD]
[TD="bgcolor: #CCCCCC"]2.5[/TD]
[TD="bgcolor: #CCCCCC"]3.5[/TD]
[TD="bgcolor: #CCCCCC"]Home[/TD]
[TD="bgcolor: #CCCCCC"]100[/TD]
[TD="bgcolor: #33A3A3"][/TD]

[TD="bgcolor: #99CCFF"]Work[/TD]

[TD="bgcolor: #33A3A3"][/TD]

[TD="bgcolor: #CCCCCC"]We[/TD]
[TD="bgcolor: #CCCCCC"]4/3[/TD]
[TD="bgcolor: #CCCCCC"] n [/TD]
[TD="bgcolor: #CCCCCC"]8.283[/TD]
[TD="bgcolor: #CCCCCC"]01:35:00[/TD]
[TD="bgcolor: #CCCCCC"]00:11:28[/TD]
[TD="bgcolor: #CCCCCC"]1214.0[/TD]
[TD="bgcolor: #CCCCCC"]5.23[/TD]
[TD="bgcolor: #CCCCCC"]5.0[/TD]
[TD="bgcolor: #CCCCCC"]5.3[/TD]
[TD="bgcolor: #CCCCCC"]2.5[/TD]
[TD="bgcolor: #CCCCCC"]2.5[/TD]
[TD="bgcolor: #CCCCCC"]Home[/TD]
[TD="bgcolor: #CCCCCC"]102[/TD]
[TD="bgcolor: #33A3A3"][/TD]

[TD="bgcolor: #99CCFF"]Work[/TD]

[TD="bgcolor: #33A3A3"][/TD]

[TD="bgcolor: #CCCCCC"]Fr[/TD]
[TD="bgcolor: #CCCCCC"]4/5[/TD]
[TD="bgcolor: #CCCCCC"] n [/TD]
[TD="bgcolor: #CCCCCC"]4.61[/TD]
[TD="bgcolor: #CCCCCC"]00:45:58[/TD]
[TD="bgcolor: #CCCCCC"]00:09:58[/TD]
[TD="bgcolor: #CCCCCC"]590.00[/TD]
[TD="bgcolor: #CCCCCC"]6.02[/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"]Park[/TD]
[TD="bgcolor: #CCCCCC"]104[/TD]
[TD="bgcolor: #33A3A3"]Brown's Park run[/TD]

[TD="bgcolor: #FFCC99"]Sa[/TD]
[TD="bgcolor: #FFCC99"]4/6[/TD]
[TD="bgcolor: #FFCC99"] o [/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"]#DIV/0![/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"]Work[/TD]
[TD="bgcolor: #FFCC99"]Train - 3 Mile[/TD]
[TD="bgcolor: #33A3A3"][/TD]

[TD="bgcolor: #99CCFF"]Work[/TD]

[TD="bgcolor: #33A3A3"][/TD]

[TD="bgcolor: #CCCCCC"]Mo[/TD]
[TD="bgcolor: #CCCCCC"]4/8[/TD]
[TD="bgcolor: #CCCCCC"] o [/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"]#DIV/0![/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"]107[/TD]
[TD="bgcolor: #33A3A3"][/TD]

[TD="bgcolor: #33A3A3"][/TD]

[TD="bgcolor: #CCCCCC"]We[/TD]
[TD="bgcolor: #CCCCCC"]4/10[/TD]
[TD="bgcolor: #CCCCCC"] o [/TD]
[TD="bgcolor: #CCCCCC"]3.100[/TD]
[TD="bgcolor: #CCCCCC"]00:35:26[/TD]
[TD="bgcolor: #CCCCCC"]00:11:26[/TD]
[TD="bgcolor: #CCCCCC"]454.0[/TD]
[TD="bgcolor: #CCCCCC"]5.25[/TD]
[TD="bgcolor: #CCCCCC"]5.2[/TD]
[TD="bgcolor: #CCCCCC"]5.3[/TD]
[TD="bgcolor: #CCCCCC"]2.5[/TD]
[TD="bgcolor: #CCCCCC"]2.5[/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"]Train - 3 Mile[/TD]
[TD="bgcolor: #33A3A3"][/TD]

[TD="bgcolor: #99CCFF"]Work[/TD]

[TD="bgcolor: #33A3A3"][/TD]

[TD="bgcolor: #CCCCCC"]Fr[/TD]
[TD="bgcolor: #CCCCCC"]4/12[/TD]
[TD="bgcolor: #CCCCCC"] o [/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"]#DIV/0![/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"]Train - 1 Mile[/TD]
[TD="bgcolor: #33A3A3"][/TD]

[TD="bgcolor: #FFCC99"]Sa[/TD]
[TD="bgcolor: #FFCC99"]4/13[/TD]
[TD="bgcolor: #FFCC99"] o [/TD]
[TD="bgcolor: #FFCC99"]13.100[/TD]
[TD="bgcolor: #FFCC99"]02:09:31[/TD]
[TD="bgcolor: #FFCC99"]00:09:53[/TD]
[TD="bgcolor: #FFCC99"]1622.0[/TD]
[TD="bgcolor: #FFCC99"]6.07[/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"]Park[/TD]
[TD="bgcolor: #FFCC99"] RACE DAY [/TD]
[TD="bgcolor: #33A3A3"] Eisenhower Half Marathon [/TD]

[TD="bgcolor: #CCCCCC"]Mo[/TD]
[TD="bgcolor: #CCCCCC"]4/15[/TD]
[TD="bgcolor: #CCCCCC"] o [/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"]#DIV/0![/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"]Work[/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]

[TD="bgcolor: #CCCCCC"]We[/TD]
[TD="bgcolor: #CCCCCC"]4/17[/TD]
[TD="bgcolor: #CCCCCC"] o [/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"]#DIV/0![/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"]#DIV/0![/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"]3[/TD]
[TD="bgcolor: #CCCCCC"][/TD]

[TD="bgcolor: #CCCCCC"]Fr[/TD]
[TD="bgcolor: #CCCCCC"]4/19[/TD]
[TD="bgcolor: #CCCCCC"] o [/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"]#DIV/0![/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"]#DIV/0![/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"][/TD]
[TD="bgcolor: #CCCCCC"]10[/TD]
[TD="bgcolor: #CCCCCC"][/TD]

[TD="bgcolor: #FFCC99"]Sa[/TD]
[TD="bgcolor: #FFCC99"]4/20[/TD]
[TD="bgcolor: #FFCC99"] o [/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"]#DIV/0![/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"]#DIV/0![/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"]Work[/TD]
[TD="bgcolor: #FFCC99"][/TD]
[TD="bgcolor: #FFCC99"][/TD]

</tbody>
 
Upvote 0
So does anyone know how to get a countif to work work for if column A3:331 = "Su" then to count D3:331?

I have tried several different variations without success.
 
Upvote 0
You must log in or register to reply here.

Similar threads

Vintage79
  • Solved
Count consecutive days and gaps between days
Replies
2
Views
205
Vintage79
Vintage79
D
  • Solved
IF, IF(And(countif)) formula not working correctly
Replies
5
Views
479
SanjayGMusafir
SanjayGMusafir
M
  • Solved
How to Countif for the current week
Replies
4
Views
526
Peter_SSs
Peter_SSs
C
  • Solved
Referencing accrued leave value for last last months last working day
Replies
5
Views
480
Peter_SSs
Peter_SSs
T
  • Question Question
automatic show start day and last day of each week when select week1, week2, ...
Replies
2
Views
724
Dave Patton
D

Forum statistics

Threads
1,223,262
Messages
6,171,080
Members
452,377
Latest member
bradfordsam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top