countif yesterday

[rustynailed]

Hi all

I need to be able to produce a report that demonstrates number of accounts actioned yesterdays date. the cell the users enter is a a date for when they last actioned the record. Im only tracking the previous day, nothing older

<TABLE style="WIDTH: 155pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=207><COLGROUP><COL style="WIDTH: 155pt; mso-width-source: userset; mso-width-alt: 7570" width=207><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #f2dcdb; WIDTH: 155pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl63 height=20 width=207>Actioned Accounts Yesterday</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d9d9d9; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl64 height=20>36</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d9d9d9; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl64 height=20>43</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt dotted; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d9d9d9; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl64 height=20>39</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #c4bd97; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl65 height=20>118</TD></TR></TBODY></TABLE>

Thanks

 

[rustynailed]

Dont worry about it, answered my own question

=COUNTIFS('T2 SOM Aug 2011'!$P:$P,A17,'T2 SOM Aug 2011'!$T:$T,TODAY()-1)