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>
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

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)
 

Watch MrExcel Video

Forum statistics

Threads
1,132,878
Messages
5,655,766
Members
418,236
Latest member
jess5789

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
Top