Count Number of Times "Yes" appears between two dates

H

highflight1985

New Member
Joined
Jun 8, 2011
Messages
20
I'm trying to count the number of times "yes" appears in a column (N4:N563) between two dates (start date = A27, end date = A28, but I keep getting zero. I'm using the formula from this thread and trying to modify to work for me. But it's not...

Here's my formula:

=SUMPRODUCT(('Load Entry'!$N$4:$N$563="Yes")*('Load Entry'!$N$4:$N$563>=$A$28)*('Load Entry'!$N$4:$N$563>=$A$27))

Where am I going wrong?
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Sort by date Sort by votes
What do the two dates have to do with this?

Are you trying to count "Yes" in range (N4:N563)?

then just use
Code: 
=COUNTIF($N$4:$N$563, "Yes")

The formula is case-sensitive.
 
Upvote 0
Because I don't want to count every time Yes appears...

The 'Load Entry' worksheet has entries for the entire year. In the cell I'm trying to calculate right now, I only want the number of times "yes" appears in a column on that Load Entry worksheet in a portion of a given year...
 
Upvote 0
Aladin Akyurek said:
Does 'Load Entry'!$N$4:$N$563 really house Yes values as well as dates?
Click to expand...

No...N4:N563 on the load entry sheet houses the "yes" values. A27 and A28 on the active worksheet where this formula will go houses the date range. C4:C563 on the load entry sheet houses the dates themselves.
 
Upvote 0
highflight1985 said:
I'm trying to count the number of times "yes" appears in a column (N4:N563) between two dates (start date = A27, end date = A28, but I keep getting zero. I'm using the formula from this thread and trying to modify to work for me. But it's not...

Here's my formula:

=SUMPRODUCT(('Load Entry'!$N$4:$N$563="Yes")*('Load Entry'!$N$4:$N$563>=$A$28)*('Load Entry'!$N$4:$N$563>=$A$27))

Where am I going wrong?
Click to expand...
You're referencing the same range for both the dates and the condition of "yes".

Typically, the dates would be in one column and the "yes" entries would be in another column.

Book1
ABCDE
212/17/2006Yes_1/1/201012/31/2010
33/31/2001No___
41/14/2010Yes_4
51/10/2014Yes___
64/7/2010No___
79/4/2008No___
83/24/2010Yes___
98/9/2003No___
102/21/2012Yes___
117/27/2010No___
126/26/2014Yes___
1310/23/2010Yes___
147/27/2006Yes___
154/21/2010Yes___
Sheet3

Formula entered in E4:

=SUMPRODUCT(--(A2:A15>=D2),--(A2:A15<=E2),--(B2:B15="yes"))
 
Upvote 0
highflight1985 said:
No...N4:N563 on the load entry sheet houses the "yes" values. A27 and A28 on the active worksheet where this formula will go houses the date range. C4:C563 on the load entry sheet houses the dates themselves.
Click to expand...

Looks like you want...
Code: 
=SUMPRODUCT(
    --('Load Entry'!$N$4:$N$563="Yes"),
    --('Load Entry'!$C$4:$C$563>=$A$27),
    --('Load Entry'!$C$4:$C$563<=$A$28))
 
Upvote 0
Okay, for clarity, on "Load Entry" I have this:

<TABLE style="WIDTH: 141pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=188><COLGROUP><COL style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2073" width=65><COL style="WIDTH: 43pt; mso-width-source: userset; mso-width-alt: 1843" width=58><COL style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2073" width=65><TBODY><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #bfbfbf; WIDTH: 49pt; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl74 height=18 width=65>
C​
</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; WIDTH: 43pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl74 width=58>
...​
</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; WIDTH: 49pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl74 width=65>
N​
</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 height=18 align=right>1/1/10</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right>Yes</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 height=18 align=right>1/1/10</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl73 align=right>No</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 height=18 align=right>1/6/10</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl73 align=right>Yes</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 height=18 align=right>1/7/10</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl73 align=right>Yes</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 height=18 align=right>1/8/10</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl73 align=right>No</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 height=18 align=right>1/9/10</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl73 align=right>No</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 height=18 align=right>1/11/10</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl73 align=right>No</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 height=18 align=right>1/13/10</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl73 align=right>Yes</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 height=18 align=right>1/16/10</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl73 align=right>Yes</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 height=18 align=right>1/19/10</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl73 align=right>Yes</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 height=18 align=right>1/20/10</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl73 align=right>Yes</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 height=18 align=right>1/22/10</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl73 align=right>No</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 height=18 align=right>1/23/10</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl73 align=right>No</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 height=18 align=right>1/25/10</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl73 align=right>No</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 height=18 align=right>1/26/10</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl73 align=right>No</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 height=18 align=right>1/29/10</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>Yes</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 13.8pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 height=18 align=right>2/3/10</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>No</TD></TR></TBODY></TABLE>

Then, on the sheet where this formula is to count, I have this:

<TABLE style="WIDTH: 256pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=344><COLGROUP><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 2739" span=4 width=86><TBODY><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d9d9d9; WIDTH: 64pt; HEIGHT: 13.8pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl70 height=18 width=86 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #d9d9d9; WIDTH: 64pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=86 align=right>A</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #d9d9d9; WIDTH: 64pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=86 align=right>B</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #d9d9d9; WIDTH: 64pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=86 align=right>C</TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d9d9d9; HEIGHT: 13.8pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl69 height=18 align=right>1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right></TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d9d9d9; HEIGHT: 13.8pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 height=18 align=right>...</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right></TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d9d9d9; HEIGHT: 13.8pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 height=18 align=right>9</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>Number of Matches:</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>(where the formula goes)</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right></TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d9d9d9; HEIGHT: 13.8pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl72 height=18 align=right>...</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right></TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d9d9d9; HEIGHT: 13.8pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl73 height=18 align=right>27</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl73 align=right>1/1/10</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl73 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl73 align=right></TD></TR><TR style="HEIGHT: 13.8pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #d9d9d9; HEIGHT: 13.8pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl74 height=18 align=right>28</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl74 align=right>1/8/10</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl74 align=right></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #d9d9d9; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl74 align=right></TD></TR></TBODY></TABLE>

So, in cell B9 should be where the formula goes, using dates from A27 and A28, searching through dates on 'Load Entry''s C column, and matching any "Yes"s in "Load Entry''s N column....
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
count how many times text string appears in column
Replies
2
Views
222
ajm
A
P
  • Question Question
TypeScript (or other solutions) for modifying given list of cells (and similar problems)
Replies
0
Views
259
Pingaware
P
S
  • Question Question
Sumproduct - to count occasions in a date range
Replies
3
Views
462
Cubist
Cubist
A
  • Question Question
Counting cells with specific text within two dates
Replies
2
Views
310
Cubist
Cubist
S
  • Question Question
How can I exactly count NETWORKDAYS in multiple date ranges, after a specific date?
Replies
1
Views
236
Tetra201
Tetra201

Forum statistics

Threads
1,224,608
Messages
6,179,872
Members
452,949
Latest member
Dupuhini

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