countif problem

[Legacy 169354]

Hi,

I have a simple task that needs to count the rows that fit the criteria below:

1) count the dates that equal month AND year of the date column and then places that count in the column of the first date change.


<table border="0" cellpadding="0" cellspacing="0" width="128"><col style="width: 48pt;" span="2" width="64"> <tbody><tr style="height: 15.75pt;" height="21"> <td class="xl65" style="height: 15.75pt; width: 48pt;" height="21" width="64">date
</td> <td class="xl65" style="width: 48pt;" width="64"> total</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">Jan-07</td> <td class="xl65"> 3</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">Jan-07</td> <td class="xl65">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">Jan-07</td> <td class="xl65">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">Feb-07</td> <td class="xl65"> 4</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">Feb-07</td> <td class="xl65">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl66" style="height: 15.75pt;" height="21">Feb-07</td> <td class="xl65">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">Feb-07</td> <td class="xl65">
</td> </tr> </tbody></table>

for some reason count if aint working for me.
There are about 1000 rows of dates I need a count for.
Thanks!
PS - Excel 2003

 

[JoeMo]

Sheet1

<table style="font-family: Calibri,Arial; font-size: 11pt; background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight: bold; width: 30px;"><col style="width: 64px;"><col style="width: 64px;"></colgroup><tbody><tr style="background-color: rgb(202, 202, 202); text-align: center; font-weight: bold; font-size: 8pt;"><td>
</td><td>A</td><td>B</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">1</td><td>date</td><td>total</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">2</td><td style="text-align: right;">Jan-07</td><td style="text-align: right;">3</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">3</td><td style="text-align: right;">Jan-07</td><td>
</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">4</td><td style="text-align: right;">Jan-07</td><td>
</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">5</td><td style="text-align: right;">Feb-07</td><td style="text-align: right;">4</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">6</td><td style="text-align: right;">Feb-07</td><td>
</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">7</td><td style="text-align: right;">Feb-07</td><td>
</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">8</td><td style="text-align: right;">Feb-07</td><td>
</td></tr></tbody></table>
<table style="font-family: Arial; font-size: 10pt; border-style: groove; border-color: rgb(0, 255, 0); background-color: rgb(255, 252, 249); color: rgb(0, 0, 0);"><tbody><tr><td>Spreadsheet Formulas</td></tr><tr><td><table style="font-family: Arial; font-size: 9pt;" border="1" cellpadding="2" cellspacing="0"><tbody><tr style="background-color: rgb(202, 202, 202); font-size: 10pt;"><td>Cell</td><td>Formula</td></tr><tr><td>B2</td><td>=IF(A2<>A1,COUNTIF($A$2:$A$8,A2),"")</td></tr></tbody></table></td></tr></tbody></table>
Copy the formula in B2 as far down the column as needed, changing the$A$8 address to correspond.
Excel tables to the web >> Excel Jeanie HTML 4

 

[jeffreybrown]

Have you considered a pivot table?

 

[Legacy 169354]

oh sorry,
didnt se the replies!

Pivot table wont work in this case I dont think

Thanks for the formula:
=IF(A2<>A1,COUNTIF($A$2:$A$8,A2),"")

however, I need to assess the month and year specifically. The reason is the cell A2 references a date cell by (=d1) and therefore has the value not similar to the same month and year as the day is in there

 

[Legacy 169354]

Thanks for the formula:
=IF(A2<>A1,COUNTIF($A$2:$A$8,A2),"")

however, I need to assess the month and year specifically. The reason is the cell A2 references a date cell by (=d1) and therefore has the value not similar to the same month and year as the day is in there

 

[Haseeb Avarakkan]

Hello, Try

B2, copy down...

=IF(TEXT(A1,"mmyyyy")<>TEXT(A2,"mmyyyy"),COUNTIF(A:A,">="&A2-DAY(A2)+1)-COUNTIF(A:A,">"&EOMONTH(A2,0)),"")

 

[Legacy 169354]

Hello, Try

B2, copy down...

=IF(TEXT(A1,"mmyyyy")<>TEXT(A2,"mmyyyy"),COUNTIF(A:A,">="&A2-DAY(A2)+1)-COUNTIF(A:A,">"&EOMONTH(A2,0)),"")

Hi thanks for that,
it seems to be giving me a total count. any suggestions?

thank you!

 

[Haseeb Avarakkan]

Hi,

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">date</td><td style=";">total</td><td style="text-align: right;;"></td><td style=";">Enter year</td><td style="text-align: right;;">2007</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">Jan-07</td><td style="text-align: right;;">3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">Jan-07</td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">Jan-07</td><td style="text-align: right;;">Feb-07</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;">Jan-07</td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">3</td><td style="text-align: right;;">4</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">Feb-07</td><td style="text-align: right;;">4</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;">Feb-07</td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">Feb-07</td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;">Feb-07</td><td style=";"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet8</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B2</th><td style="text-align:left">=IF(<font color="Blue">TEXT(<font color="Red">A1,"mmyyyy"</font>)<>TEXT(<font color="Red">A2,"mmyyyy"</font>),COUNTIF(<font color="Red">A:A,">="&A2-DAY(<font color="Green">A2</font>)+1</font>)-COUNTIF(<font color="Red">A:A,">"&EOMONTH(<font color="Green">A2,0</font>)</font>),""</font>)</td></tr></tbody></table></td></tr></table><br />
Do you need the count in the 2nd col? As Jeff suggested a Pivot Table can give you the whole month count. also formulas.

Is it Ok shown in the D1:E2 for the count?

 

[Legacy 169354]

Thank you Haseeb!

seemed to work now, must have been finger trouble adjusting formula!

 

[Legacy 169354]

Hi Haseeb,
the formula works good on H376, but on H367 give a wrong count. Can you see if I am entering incorrectly? Thanks
<table style="background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt; font-family: Arial,Arial; font-size: 10pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="width: 30px; font-weight: bold;"> <col style="width: 81px;"> <col style="width: 127px;"> <col style="width: 92px;"> <col style="width: 83px;"> <col style="width: 71px;"> <col style="width: 104px;"> <col style="width: 118px;"> <col style="width: 118px;"></colgroup> <tbody> <tr style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt; font-weight: bold;"> <td> </td> <td>A</td> <td>B</td> <td>C</td> <td>D</td> <td>E</td> <td>F</td> <td>G</td> <td>H</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">366</td> <td style="text-align: center;">Jan-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">6012</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">28-Jan-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">10:48</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">SYD</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Take off</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Eagle</td> <td> </td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">367</td> <td style="text-align: center;">Feb-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">6049</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">02-Feb-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">12:00</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">BHQ</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Landing</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Sparrow</td> <td style="text-align: center;">17</td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">368</td> <td style="text-align: center;">Feb-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">6105</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">11-Feb-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">00:00</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">WYA</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Landing</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Plover</td> <td> </td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">369</td> <td style="text-align: center;">Feb-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">6121</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">14-Feb-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">07:12</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">OAG</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Take off</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Galah</td> <td> </td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">370</td> <td style="text-align: center;">Feb-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">6161</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">17-Feb-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">03:36</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">SYD</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Take off</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Galah</td> <td> </td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">371</td> <td style="text-align: center;">Feb-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">6166</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">19-Feb-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">01:12</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">BWT</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Taxi</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Plover</td> <td> </td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">372</td> <td style="text-align: center;">Feb-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">6169</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">20-Feb-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">12:00</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">SYD</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Take off</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Kestrel</td> <td> </td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">373</td> <td style="text-align: center;">Feb-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">6197</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">24-Feb-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">00:00</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">WGA</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Landing</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Sparrow</td> <td> </td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">374</td> <td style="text-align: center;">Feb-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">6200</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">25-Feb-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">01:12</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">ADL</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Landing</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Magpie</td> <td> </td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">375</td> <td style="text-align: center;">Feb-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">6205</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">25-Feb-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">02:24</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">RCM</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Landing</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Kite</td> <td> </td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">376</td> <td style="text-align: center;">Mar-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">6264</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">07-Mar-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">09:30</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">OAG</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Landing</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Galah</td> <td style="text-align: right;">8</td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">377</td> <td style="text-align: center;">Mar-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">6297</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">09-Mar-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">20:05</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">LSY</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Approach</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Fruit Bat</td> <td> </td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">378</td> <td style="text-align: center;">Mar-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">6306</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">11-Mar-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">10:00</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">ADL</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Landing</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Magpie</td> <td> </td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">379</td> <td style="text-align: center;">Mar-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">6315</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">12-Mar-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">10:15</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">OAG</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Take off</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Galah</td> <td> </td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">380</td> <td style="text-align: center;">Mar-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">6332</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">14-Mar-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">18:32</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">GFF</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Take off</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">****atoo</td> <td> </td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">381</td> <td style="text-align: center;">Mar-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">6417</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">25-Mar-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">18:25</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">SYD</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Approach</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Fruit Bat</td> <td> </td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">382</td> <td style="text-align: center;">Mar-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">6433</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">28-Mar-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">19:30</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">TRO</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Take off</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Fruit Bat</td> <td> </td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">383</td> <td style="text-align: center;">Mar-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">6434</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">29-Mar-11</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">08:00</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">SYD</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Take off</td> <td style="text-align: center; background-color: rgb(204, 255, 204);">Seagulls</td> <td> </td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">384</td> <td> </td> <td style="background-color: rgb(204, 255, 204);"> </td> <td style="background-color: rgb(204, 255, 204);"> </td> <td style="background-color: rgb(204, 255, 204);"> </td> <td style="background-color: rgb(204, 255, 204);"> </td> <td style="background-color: rgb(204, 255, 204);"> </td> <td style="background-color: rgb(204, 255, 204);"> </td> <td style="text-align: right;">0</td></tr> <tr style="height: 17px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">385</td> <td> </td> <td style="background-color: rgb(204, 255, 204);"> </td> <td style="background-color: rgb(204, 255, 204);"> </td> <td style="background-color: rgb(204, 255, 204);"> </td> <td style="background-color: rgb(204, 255, 204);"> </td> <td style="background-color: rgb(204, 255, 204);"> </td> <td style="background-color: rgb(204, 255, 204);"> </td> <td> </td></tr></tbody></table>
<table style="border-style: groove; border-color: rgb(0, 255, 0); background-color: rgb(255, 252, 249); font-family: Arial; color: rgb(0, 0, 0); font-size: 10pt;"> <tbody> <tr> <td>Spreadsheet Formulas</td></tr> <tr> <td> <table style="font-family: Arial; font-size: 9pt;" border="1" cellpadding="2" cellspacing="0"> <tbody> <tr style="background-color: rgb(202, 202, 202); font-size: 10pt;"> <td>Cell</td> <td>Formula</td></tr> <tr> <td>A366</td> <td>=C366</td></tr> <tr> <td>A367</td> <td>=C367</td></tr> <tr> <td>H367</td> <td>=IF(TEXT(A366,"mmyy")<>TEXT(A367,"mmyy"),COUNTIF($A$3:$A$1000,">="&A367-DAY(A367)+1)-COUNTIF($A$3:$A$1000,">"&EOMONTH(A367,0)),"")</td></tr> <tr> <td>A368</td> <td>=C368</td></tr> <tr> <td>A369</td> <td>=C369</td></tr> <tr> <td>A370</td> <td>=C370</td></tr> <tr> <td>A371</td> <td>=C371</td></tr> <tr> <td>A372</td> <td>=C372</td></tr> <tr> <td>A373</td> <td>=C373</td></tr> <tr> <td>A374</td> <td>=C374</td></tr> <tr> <td>A375</td> <td>=C375</td></tr> <tr> <td>A376</td> <td>=C376</td></tr> <tr> <td>H376</td> <td>=IF(TEXT(A375,"mmyyyy")<>TEXT(A376,"mmyyyy"),COUNTIF($A$3:$A$1000,">="&A376-DAY(A376)+1)-COUNTIF($A$3:$A$1000,">"&EOMONTH(A376,0)),"")</td></tr></tbody></table></td></tr></tbody></table>