Count if

bllanko

New Member
Joined
Jul 16, 2009
Messages
42
****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 11">****** name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CTEMP%5Cmsohtml1%5C01%5Cclip_filelist.xml"><title></title><!--[if gte mso 9]><xml> <o:DocumentProperties> <o:Author>DCMDI</o:Author> <o:Version>11.9999</o:Version> </o:DocumentProperties> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0pt; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline; text-underline:single;} span.EmailStyle16 {mso-style-type:personal; mso-style-noshow:yes; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; font-family:Arial; mso-ascii-font-family:Arial; mso-hansi-font-family:Arial; mso-bidi-font-family:Arial; color:windowtext;} @page Section1 {size:612.0pt 792.0pt; margin:72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0pt 5.4pt 0pt 5.4pt; mso-para-margin:0pt; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> Hello,<o:p></o:p>
<o:p> </o:p>
I need some help with my excel spread sheet please. Ok, I need to know what formula I need if. On sheet 1 I have my vehicle waiting shop and I’m filling out daily. On column D1 = today() and E1 I have my total number for today based on today’s date. And this is living documents so for next day I delete or add any vehicle.<o:p></o:p>
<o:p> </o:p>
<table class="MsoNormalTable" style="width: 539.95pt; border-collapse: collapse;" width="720" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 13.5pt;"> <td style="width: 61.8pt; background: none repeat scroll 0% 0% silver; padding: 0pt 5.4pt; height: 13.5pt;" valign="bottom" width="82" nowrap="nowrap">
<o:p></o:p>
</td> <td style="width: 208.15pt; background: none repeat scroll 0% 0% silver; padding: 0pt 5.4pt; height: 13.5pt;" valign="bottom" width="278" nowrap="nowrap">
<o:p></o:p>
</td> <td style="width: 99pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% silver; padding: 0pt 5.4pt; height: 13.5pt;" x:num="40394" x:fmla="=TODAY()" valign="bottom" width="132" nowrap="nowrap">
8/4/2010<o:p></o:p>
</td> <td style="width: 99pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% silver; padding: 0pt 5.4pt; height: 13.5pt;" valign="bottom" width="132" nowrap="nowrap">
Waiting Shop<o:p></o:p>
</td> <td style="width: 72pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% silver; padding: 0pt 5.4pt; height: 13.5pt;" x:num="" valign="bottom" width="96" nowrap="nowrap">
121<o:p></o:p>
</td> </tr> <tr style="height: 13.5pt;"> <td colspan="2" style="width: 269.95pt; border-width: 1pt medium 1pt 1pt; border-style: solid none solid solid; border-color: windowtext -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% silver; padding: 0pt 5.4pt; height: 13.5pt;" valign="bottom" width="360" nowrap="nowrap"> VEHICLE WAITING SHOP<o:p></o:p>
</td> <td style="width: 99pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% silver; padding: 0pt 5.4pt; height: 13.5pt;" valign="bottom" width="132" nowrap="nowrap"> <o:p></o:p>
</td> <td style="width: 99pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% silver; padding: 0pt 5.4pt; height: 13.5pt;" valign="bottom" width="132" nowrap="nowrap">
AVERAGE DAYS<o:p></o:p>
</td> <td style="width: 72pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% silver; padding: 0pt 5.4pt; height: 13.5pt;" x:num="7.5041322314049586" valign="bottom" width="96" nowrap="nowrap">
8<o:p></o:p>
</td> </tr> <tr style="height: 12pt;"> <td style="width: 61.8pt; border-right: 1pt solid windowtext; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% silver; padding: 0pt 5.4pt; height: 12pt;" valign="bottom" width="82" nowrap="nowrap">
GP<o:p></o:p>
</td> <td style="width: 208.15pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% silver; padding: 0pt 5.4pt; height: 12pt;" valign="bottom" width="278" nowrap="nowrap">
Work Description<o:p></o:p>
</td> <td style="width: 99pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% silver; padding: 0pt 5.4pt; height: 12pt;" valign="bottom" width="132" nowrap="nowrap">
Start Date Aging<o:p></o:p>
</td> <td style="width: 99pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% silver; padding: 0pt 5.4pt; height: 12pt;" x:str="Current Date Aging " valign="bottom" width="132" nowrap="nowrap">
Current Date Aging <o:p></o:p>
</td> <td style="width: 72pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% silver; padding: 0pt 5.4pt; height: 12pt;" valign="bottom" width="96" nowrap="nowrap">
Days<o:p></o:p>
</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 61.8pt; border-right: 1pt solid windowtext; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% white; padding: 0pt 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="82" nowrap="nowrap">
7655<o:p></o:p>
</td> <td style="width: 208.15pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% white; padding: 0pt 5.4pt; height: 12.75pt;" valign="bottom" width="278" nowrap="nowrap">
WILL NOT START & SERVICE (NEW PARKING )<o:p></o:p>
</td> <td style="width: 99pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% white; padding: 0pt 5.4pt; height: 12.75pt;" x:num="40370" valign="bottom" width="132" nowrap="nowrap">
11-Jul-10<o:p></o:p>
</td> <td style="width: 99pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt; height: 12.75pt;" x:num="40394" x:fmla="=TODAY()" valign="bottom" width="132" nowrap="nowrap">
4-Aug-10<o:p></o:p>
</td> <td style="width: 72pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt; height: 12.75pt;" x:num="" x:fmla="=D4-C4" valign="bottom" width="96" nowrap="nowrap">
24<o:p></o:p>
</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 61.8pt; border-right: 1pt solid windowtext; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% white; padding: 0pt 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="82" nowrap="nowrap">
9009<o:p></o:p>
</td> <td style="width: 208.15pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% white; padding: 0pt 5.4pt; height: 12.75pt;" valign="bottom" width="278" nowrap="nowrap">
CHECK CLUTCH & SERVICE (NEW PARKING )DEADLINE<o:p></o:p>
</td> <td style="width: 99pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% white; padding: 0pt 5.4pt; height: 12.75pt;" x:num="40373" valign="bottom" width="132" nowrap="nowrap">
14-Jul-10<o:p></o:p>
</td> <td style="width: 99pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt; height: 12.75pt;" x:num="40394" x:fmla="=TODAY()" valign="bottom" width="132" nowrap="nowrap">
4-Aug-10<o:p></o:p>
</td> <td style="width: 72pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt; height: 12.75pt;" x:num="" x:fmla="=D5-C5" valign="bottom" width="96" nowrap="nowrap">
21<o:p></o:p>
</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 61.8pt; border-right: 1pt solid windowtext; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% white; padding: 0pt 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="82" nowrap="nowrap">
9606<o:p></o:p>
</td> <td style="width: 208.15pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% white; padding: 0pt 5.4pt; height: 12.75pt;" valign="bottom" width="278" nowrap="nowrap">
CHECK ELECTRICAL PROBLEM (NEW PARKING )<o:p></o:p>
</td> <td style="width: 99pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% white; padding: 0pt 5.4pt; height: 12.75pt;" x:num="40374" valign="bottom" width="132" nowrap="nowrap">
15-Jul-10<o:p></o:p>
</td> <td style="width: 99pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt; height: 12.75pt;" x:num="40394" x:fmla="=TODAY()" valign="bottom" width="132" nowrap="nowrap">
4-Aug-10<o:p></o:p>
</td> <td style="width: 72pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt; height: 12.75pt;" x:num="" x:fmla="=D6-C6" valign="bottom" width="96" nowrap="nowrap">
20<o:p></o:p>
</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 61.8pt; border-right: 1pt solid windowtext; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% white; padding: 0pt 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="82" nowrap="nowrap">
7145<o:p></o:p>
</td> <td style="width: 208.15pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% white; padding: 0pt 5.4pt; height: 12.75pt;" x:str="TI FOR TURN IN " valign="bottom" width="278" nowrap="nowrap">
TI FOR TURN IN <o:p></o:p>
</td> <td style="width: 99pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% white; padding: 0pt 5.4pt; height: 12.75pt;" x:num="40375" valign="bottom" width="132" nowrap="nowrap">
16-Jul-10<o:p></o:p>
</td> <td style="width: 99pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt; height: 12.75pt;" x:num="40394" x:fmla="=TODAY()" valign="bottom" width="132" nowrap="nowrap">
4-Aug-10<o:p></o:p>
</td> <td style="width: 72pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt; height: 12.75pt;" x:num="" x:fmla="=D7-C7" valign="bottom" width="96" nowrap="nowrap">
19<o:p></o:p>
</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 61.8pt; border-right: 1pt solid windowtext; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% white; padding: 0pt 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="82" nowrap="nowrap">
7663<o:p></o:p>
</td> <td style="width: 208.15pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% white; padding: 0pt 5.4pt; height: 12.75pt;" valign="bottom" width="278" nowrap="nowrap">
PERFORM PRE -DELIVERY INSPECTION AS PER ACL<o:p></o:p>
</td> <td style="width: 99pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% white; padding: 0pt 5.4pt; height: 12.75pt;" x:num="40375" valign="bottom" width="132" nowrap="nowrap">
16-Jul-10<o:p></o:p>
</td> <td style="width: 99pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt; height: 12.75pt;" x:num="40394" x:fmla="=TODAY()" valign="bottom" width="132" nowrap="nowrap">
4-Aug-10<o:p></o:p>
</td> <td style="width: 72pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt; height: 12.75pt;" x:num="" x:fmla="=D8-C8" valign="bottom" width="96" nowrap="nowrap">
19<o:p></o:p>
</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 61.8pt; border-right: 1pt solid windowtext; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% white; padding: 0pt 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="82" nowrap="nowrap">
8845<o:p></o:p>
</td> <td style="width: 208.15pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% white; padding: 0pt 5.4pt; height: 12.75pt;" x:str="WILL NOT START " valign="bottom" width="278" nowrap="nowrap">
WILL NOT START <o:p></o:p>
</td> <td style="width: 99pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% white; padding: 0pt 5.4pt; height: 12.75pt;" x:num="40375" valign="bottom" width="132" nowrap="nowrap">
16-Jul-10<o:p></o:p>
</td> <td style="width: 99pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt; height: 12.75pt;" x:num="40394" x:fmla="=TODAY()" valign="bottom" width="132" nowrap="nowrap">
4-Aug-10<o:p></o:p>
</td> <td style="width: 72pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt; height: 12.75pt;" x:num="" x:fmla="=D9-C9" valign="bottom" width="96" nowrap="nowrap">
19<o:p></o:p>
</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 61.8pt; border-right: 1pt solid windowtext; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% white; padding: 0pt 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="82" nowrap="nowrap">
55296<o:p></o:p>
</td> <td style="width: 208.15pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% white; padding: 0pt 5.4pt; height: 12.75pt;" valign="bottom" width="278" nowrap="nowrap">
LF AND RF UPPER CONTROL ARMS BAD<o:p></o:p>
</td> <td style="width: 99pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% white; padding: 0pt 5.4pt; height: 12.75pt;" x:num="40375" valign="bottom" width="132" nowrap="nowrap">
16-Jul-10<o:p></o:p>
</td> <td style="width: 99pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt; height: 12.75pt;" x:num="40394" x:fmla="=TODAY()" valign="bottom" width="132" nowrap="nowrap">
4-Aug-10<o:p></o:p>
</td> <td style="width: 72pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt; height: 12.75pt;" x:num="" x:fmla="=D10-C10" valign="bottom" width="96" nowrap="nowrap">
19<o:p></o:p>
</td> </tr> </tbody></table> <o:p> </o:p>
<o:p> </o:p>
<o:p> </o:p>
<o:p> </o:p>
Now on sheet 2 I have dates for this month 1-30 Aug. I need to know based today’s date to pull the total number example 121. so while sheet 1 is living documents what formula I have to put in if the dates on c1 changes daily and the total number to show up on below screen based on column c1 from sheet 1?<o:p></o:p>
<table class="MsoNormalTable" style="width: 137pt; margin-left: -0.9pt; border-collapse: collapse;" width="183" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 43.5pt;"> <td style="width: 65pt; border: 1pt solid windowtext; background: none repeat scroll 0% 0% rgb(227, 227, 227); padding: 0pt 5.4pt; height: 43.5pt;" valign="bottom" width="87">
DATE<o:p></o:p>
</td> <td style="vertical-align: top;">
</td><td style="width: 72pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(227, 227, 227); padding: 0pt 5.4pt; height: 43.5pt;" valign="bottom" width="96">
WAITING SHOP<o:p></o:p>
</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 65pt; border-right: 1pt solid windowtext; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(227, 227, 227); padding: 0pt 5.4pt; height: 12.75pt;" x:num="40321" valign="bottom" width="87" nowrap="nowrap">
8/1/10<o:p></o:p>
</td> <td style="vertical-align: top;">
</td><td style="width: 72pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="96" nowrap="nowrap">
<o:p> </o:p>
</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 65pt; border-right: 1pt solid windowtext; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(227, 227, 227); padding: 0pt 5.4pt; height: 12.75pt;" x:num="40322" valign="bottom" width="87" nowrap="nowrap">
8/2/10<o:p></o:p>
</td> <td style="vertical-align: top;">
</td><td style="width: 72pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="96" nowrap="nowrap">
<o:p> </o:p>
</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 65pt; border-right: 1pt solid windowtext; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(227, 227, 227); padding: 0pt 5.4pt; height: 12.75pt;" x:num="40323" valign="bottom" width="87" nowrap="nowrap">
8/3/10<o:p></o:p>
</td> <td style="vertical-align: top;">
</td><td style="width: 72pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="96" nowrap="nowrap">
<o:p> </o:p>
</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 65pt; border-right: 1pt solid windowtext; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(227, 227, 227); padding: 0pt 5.4pt; height: 12.75pt;" x:num="40324" valign="bottom" width="87" nowrap="nowrap">
8/4/10<o:p></o:p>
</td> <td style="vertical-align: top;">
</td><td style="width: 72pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="96" nowrap="nowrap">
121<o:p></o:p>
</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 65pt; border-right: 1pt solid windowtext; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(227, 227, 227); padding: 0pt 5.4pt; height: 12.75pt;" x:num="40325" valign="bottom" width="87" nowrap="nowrap">
8/5/10<o:p></o:p>
</td> <td style="vertical-align: top;">
</td><td style="width: 72pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="96" nowrap="nowrap">
<o:p> </o:p>
</td> </tr> <tr style="height: 12.75pt;"> <td style="width: 65pt; border-right: 1pt solid windowtext; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(227, 227, 227); padding: 0pt 5.4pt; height: 12.75pt;" x:num="40326" valign="bottom" width="87" nowrap="nowrap">
8/6/10<o:p></o:p>
</td> <td style="vertical-align: top;">
</td><td style="width: 72pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt; height: 12.75pt;" x:num="" valign="bottom" width="96" nowrap="nowrap">
<o:p> </o:p>
</td> </tr> </tbody></table>
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

gecs

Active Member
Joined
Jan 26, 2009
Messages
320
You have to transform Sheet1 in a real database and replace the TODAY() function with a hand-written date. Keep all the records for a whole month, let's say, then you'll be able to use a COUNTIF() in the second worksheet (for B2, assuming headers in first row):

=COUNTIF([Current Date],A2)

where [Current Date] is the range you're inspecting for the appearance of the date written in A2.
 

bllanko

New Member
Joined
Jul 16, 2009
Messages
42
Re: HELPPPPPPP

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 11">****** name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CTEMP%5Cmsohtml1%5C01%5Cclip_filelist.xml"><title></title><!--[if gte mso 9]><xml> <o:DocumentProperties> <o:Author>DCMDI</o:Author> <o:Version>11.9999</o:Version> </o:DocumentProperties> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0pt; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline; text-underline:single;} span.EmailStyle16 {mso-style-type:personal; mso-style-noshow:yes; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; font-family:Arial; mso-ascii-font-family:Arial; mso-hansi-font-family:Arial; mso-bidi-font-family:Arial; color:windowtext;} @page Section1 {size:612.0pt 792.0pt; margin:72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0pt 5.4pt 0pt 5.4pt; mso-para-margin:0pt; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> Well it doesn’t work. Or I may not clear what I want it. But on next day I change the date on sheet 1 and enter new data in sheet 1 but the sum for yesterday it need to stay on yesterdays date and start with todays date now the calculation need to be for today.<o:p></o:p>
<o:p> </o:p>
So when I change the date on sheet 1 the value on sheet 2 (example 121) needs to stay.<o:p></o:p>
<o:p> </o:p>
Any other idea please?<o:p></o:p>
 

gecs

Active Member
Joined
Jan 26, 2009
Messages
320
You MUST NOT CHANGE the date in Sheet1 - you have to ADD ROWS for new dates.

If too many records in Sheet1 look confusing, use filters to display only the records for the current date.

How do you expect to do some calculation on volatile data?

There is no other alternative, but using a macro at the end of the day to append a row with the date and add the count to the table in Sheet2. Then you may change the data in Sheet1 the next day, but using only formulas to do the job will not work if you want to keep that procedure (changing the data everyday)
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,063
Messages
5,509,072
Members
408,705
Latest member
denesh3560

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top