Formula Edit to Count Uniques

Alex O

Alex O

Active Member
Joined
Mar 16, 2009
Messages
345
Office Version
  1. 365
Platform
  1. Windows
Is there a way the formula below can be edited to count only uniques in the specified range?

=COUNTIFS($A$18:$A$76242,">="&$B4,$A$18:$A$76242,"<="&$C4,$B$18:$B$76242,">="&$B4,$B$18:$B$76242,"<="&$C$1,$E$18:$E$76242,">0")
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Sort by date Sort by votes
I forgot to identify the range with the values that I'd like to get the unique count of - H17:H77000

Thanks
 
Upvote 0
Alex O said:
I forgot to identify the range with the values that I'd like to get the unique count of - H17:H77000

Thanks
Click to expand...

Are you wanting a distinct item count where the ranges meet the conditions as specified in the COUNTIFS formula you posted?
 
Upvote 0
Yes. In short, I'm trying to get the count of CLT_IDs where the List_Date and PMT_Date falls within the date range in B4:C4. Does this make sense?


<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 100px"><COL style="WIDTH: 75px"><COL style="WIDTH: 75px"><COL style="WIDTH: 84px"><COL style="WIDTH: 80px"><COL style="WIDTH: 68px"><COL style="WIDTH: 63px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; 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: #cacaca; FONT-SIZE: 8pt">4</TD><TD>List Periods</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">3/1/2012</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc">3/31/2012</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">228,863</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">314</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">228,863</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD></TD><TD style="TEXT-ALIGN: right">2/1/2012</TD><TD style="TEXT-ALIGN: right">2/29/2012</TD><TD style="TEXT-ALIGN: center">339,550</TD><TD style="TEXT-ALIGN: center">666</TD><TD style="TEXT-ALIGN: center">339,550</TD><TD style="TEXT-ALIGN: center">117,170</TD><TD style="TEXT-ALIGN: right">222,380</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc">1/1/2012</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc">1/31/2012</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">414,701</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">774</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">414,701</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">285,357</TD><TD style="TEXT-ALIGN: right">129,344</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD></TD><TD style="TEXT-ALIGN: right">12/1/2011</TD><TD style="TEXT-ALIGN: right">12/31/2011</TD><TD style="TEXT-ALIGN: center">580,457</TD><TD style="TEXT-ALIGN: center">1233</TD><TD style="TEXT-ALIGN: center">580,457</TD><TD style="TEXT-ALIGN: center">480,289</TD><TD style="TEXT-ALIGN: right">100,168</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc">11/1/2011</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc">11/30/2011</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">779,523</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">1446</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">779,523</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">695,710</TD><TD style="TEXT-ALIGN: right">83,813</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD></TD><TD style="TEXT-ALIGN: right">10/1/2011</TD><TD style="TEXT-ALIGN: right">10/31/2011</TD><TD style="TEXT-ALIGN: center">801,876</TD><TD style="TEXT-ALIGN: center">1582</TD><TD style="TEXT-ALIGN: center">801,876</TD><TD style="TEXT-ALIGN: center">753,265</TD><TD style="TEXT-ALIGN: right">48,610</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc">9/1/2011</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc">9/30/2011</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">728,428</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">1679</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">728,428</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">663,539</TD><TD style="TEXT-ALIGN: right">64,889</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD></TD><TD style="TEXT-ALIGN: right">8/1/2011</TD><TD style="TEXT-ALIGN: right">8/31/2011</TD><TD style="TEXT-ALIGN: center">919,656</TD><TD style="TEXT-ALIGN: center">1832</TD><TD style="TEXT-ALIGN: center">919,656</TD><TD style="TEXT-ALIGN: center">882,936</TD><TD style="TEXT-ALIGN: right">36,720</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc">7/1/2011</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc">7/31/2011</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">801,027</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">1330</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">801,027</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">765,682</TD><TD style="TEXT-ALIGN: right">35,344</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD></TD><TD style="TEXT-ALIGN: right">6/1/2011</TD><TD style="TEXT-ALIGN: right">6/30/2011</TD><TD style="TEXT-ALIGN: center">1,325,430</TD><TD style="TEXT-ALIGN: center">2134</TD><TD style="TEXT-ALIGN: center">1,325,430</TD><TD style="TEXT-ALIGN: center">1,277,275</TD><TD style="TEXT-ALIGN: right">48,155</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc">5/1/2011</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc">5/31/2011</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">1,078,344</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">2368</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">1,078,344</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">1,044,840</TD><TD style="TEXT-ALIGN: right">33,504</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD></TD><TD style="TEXT-ALIGN: right">4/1/2011</TD><TD style="TEXT-ALIGN: right">4/30/2011</TD><TD style="TEXT-ALIGN: center">751,000</TD><TD style="TEXT-ALIGN: center">1717</TD><TD style="TEXT-ALIGN: center">751,000</TD><TD style="TEXT-ALIGN: center">733,009</TD><TD style="TEXT-ALIGN: right">17,991</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="FONT-WEIGHT: bold">LIST_DATE</TD><TD style="FONT-WEIGHT: bold">PMT_DATE</TD><TD style="FONT-WEIGHT: bold">DEBT_ID</TD><TD style="FONT-WEIGHT: bold">PMT_CODE</TD><TD style="FONT-WEIGHT: bold">PRINC_AMT</TD><TD style="FONT-WEIGHT: bold">OVERPMT</TD><TD style="FONT-WEIGHT: bold">INT_AMT</TD><TD style="FONT-WEIGHT: bold">CLT_ID</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="TEXT-ALIGN: right">9/10/2002</TD><TD style="TEXT-ALIGN: right">4/19/2011</TD><TD style="TEXT-ALIGN: right">59941</TD><TD>DRC</TD><TD style="TEXT-ALIGN: right">436</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1010328</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: right">9/27/2002</TD><TD style="TEXT-ALIGN: right">5/20/2010</TD><TD style="TEXT-ALIGN: right">60651</TD><TD>CHK</TD><TD style="TEXT-ALIGN: right">3500</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1010463</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="TEXT-ALIGN: right">10/9/2002</TD><TD style="TEXT-ALIGN: right">5/7/2010</TD><TD style="TEXT-ALIGN: right">61727</TD><TD>CHK</TD><TD style="TEXT-ALIGN: right">495.45</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1010328</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="TEXT-ALIGN: right">11/6/2002</TD><TD style="TEXT-ALIGN: right">12/17/2010</TD><TD style="TEXT-ALIGN: right">64191</TD><TD>CHK</TD><TD style="TEXT-ALIGN: right">500</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1010465</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="TEXT-ALIGN: right">11/6/2002</TD><TD style="TEXT-ALIGN: right">1/24/2011</TD><TD style="TEXT-ALIGN: right">64191</TD><TD>CHK</TD><TD style="TEXT-ALIGN: right">500</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1010465</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="TEXT-ALIGN: right">11/13/2002</TD><TD style="TEXT-ALIGN: right">9/21/2010</TD><TD style="TEXT-ALIGN: right">64945</TD><TD>CHK</TD><TD style="TEXT-ALIGN: right">6172.62</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1010328</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="TEXT-ALIGN: right">11/5/2003</TD><TD style="TEXT-ALIGN: right">1/24/2011</TD><TD style="TEXT-ALIGN: right">81000</TD><TD>CHK</TD><TD style="TEXT-ALIGN: right">1000</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1010465</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="TEXT-ALIGN: right">11/5/2003</TD><TD style="TEXT-ALIGN: right">3/14/2011</TD><TD style="TEXT-ALIGN: right">81000</TD><TD>CHK</TD><TD style="TEXT-ALIGN: right">1000</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1010465</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="TEXT-ALIGN: right">11/5/2003</TD><TD style="TEXT-ALIGN: right">5/17/2011</TD><TD style="TEXT-ALIGN: right">81000</TD><TD>CHK</TD><TD style="TEXT-ALIGN: right">2000</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1010465</TD></TR></TBODY></TABLE>
 
Upvote 0
Alex O said:
Yes. In short, I'm trying to get the count of CLT_IDs where the List_Date and PMT_Date falls within the date range in B4:C4. Does this make sense?


<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 100px"><COL style="WIDTH: 75px"><COL style="WIDTH: 75px"><COL style="WIDTH: 84px"><COL style="WIDTH: 80px"><COL style="WIDTH: 68px"><COL style="WIDTH: 63px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; 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: #cacaca; FONT-SIZE: 8pt">4</TD><TD>List Periods</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff00">3/1/2012</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc">3/31/2012</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">228,863</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">314</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">228,863</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">0</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD></TD><TD style="TEXT-ALIGN: right">2/1/2012</TD><TD style="TEXT-ALIGN: right">2/29/2012</TD><TD style="TEXT-ALIGN: center">339,550</TD><TD style="TEXT-ALIGN: center">666</TD><TD style="TEXT-ALIGN: center">339,550</TD><TD style="TEXT-ALIGN: center">117,170</TD><TD style="TEXT-ALIGN: right">222,380</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc">1/1/2012</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc">1/31/2012</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">414,701</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">774</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">414,701</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">285,357</TD><TD style="TEXT-ALIGN: right">129,344</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD></TD><TD style="TEXT-ALIGN: right">12/1/2011</TD><TD style="TEXT-ALIGN: right">12/31/2011</TD><TD style="TEXT-ALIGN: center">580,457</TD><TD style="TEXT-ALIGN: center">1233</TD><TD style="TEXT-ALIGN: center">580,457</TD><TD style="TEXT-ALIGN: center">480,289</TD><TD style="TEXT-ALIGN: right">100,168</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc">11/1/2011</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc">11/30/2011</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">779,523</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">1446</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">779,523</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">695,710</TD><TD style="TEXT-ALIGN: right">83,813</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD></TD><TD style="TEXT-ALIGN: right">10/1/2011</TD><TD style="TEXT-ALIGN: right">10/31/2011</TD><TD style="TEXT-ALIGN: center">801,876</TD><TD style="TEXT-ALIGN: center">1582</TD><TD style="TEXT-ALIGN: center">801,876</TD><TD style="TEXT-ALIGN: center">753,265</TD><TD style="TEXT-ALIGN: right">48,610</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc">9/1/2011</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc">9/30/2011</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">728,428</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">1679</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">728,428</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">663,539</TD><TD style="TEXT-ALIGN: right">64,889</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD></TD><TD style="TEXT-ALIGN: right">8/1/2011</TD><TD style="TEXT-ALIGN: right">8/31/2011</TD><TD style="TEXT-ALIGN: center">919,656</TD><TD style="TEXT-ALIGN: center">1832</TD><TD style="TEXT-ALIGN: center">919,656</TD><TD style="TEXT-ALIGN: center">882,936</TD><TD style="TEXT-ALIGN: right">36,720</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc">7/1/2011</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc">7/31/2011</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">801,027</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">1330</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">801,027</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">765,682</TD><TD style="TEXT-ALIGN: right">35,344</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD></TD><TD style="TEXT-ALIGN: right">6/1/2011</TD><TD style="TEXT-ALIGN: right">6/30/2011</TD><TD style="TEXT-ALIGN: center">1,325,430</TD><TD style="TEXT-ALIGN: center">2134</TD><TD style="TEXT-ALIGN: center">1,325,430</TD><TD style="TEXT-ALIGN: center">1,277,275</TD><TD style="TEXT-ALIGN: right">48,155</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc">5/1/2011</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc">5/31/2011</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">1,078,344</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">2368</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">1,078,344</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc">1,044,840</TD><TD style="TEXT-ALIGN: right">33,504</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD></TD><TD style="TEXT-ALIGN: right">4/1/2011</TD><TD style="TEXT-ALIGN: right">4/30/2011</TD><TD style="TEXT-ALIGN: center">751,000</TD><TD style="TEXT-ALIGN: center">1717</TD><TD style="TEXT-ALIGN: center">751,000</TD><TD style="TEXT-ALIGN: center">733,009</TD><TD style="TEXT-ALIGN: right">17,991</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="FONT-WEIGHT: bold">LIST_DATE</TD><TD style="FONT-WEIGHT: bold">PMT_DATE</TD><TD style="FONT-WEIGHT: bold">DEBT_ID</TD><TD style="FONT-WEIGHT: bold">PMT_CODE</TD><TD style="FONT-WEIGHT: bold">PRINC_AMT</TD><TD style="FONT-WEIGHT: bold">OVERPMT</TD><TD style="FONT-WEIGHT: bold">INT_AMT</TD><TD style="FONT-WEIGHT: bold">CLT_ID</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="TEXT-ALIGN: right">9/10/2002</TD><TD style="TEXT-ALIGN: right">4/19/2011</TD><TD style="TEXT-ALIGN: right">59941</TD><TD>DRC</TD><TD style="TEXT-ALIGN: right">436</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1010328</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: right">9/27/2002</TD><TD style="TEXT-ALIGN: right">5/20/2010</TD><TD style="TEXT-ALIGN: right">60651</TD><TD>CHK</TD><TD style="TEXT-ALIGN: right">3500</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1010463</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="TEXT-ALIGN: right">10/9/2002</TD><TD style="TEXT-ALIGN: right">5/7/2010</TD><TD style="TEXT-ALIGN: right">61727</TD><TD>CHK</TD><TD style="TEXT-ALIGN: right">495.45</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1010328</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="TEXT-ALIGN: right">11/6/2002</TD><TD style="TEXT-ALIGN: right">12/17/2010</TD><TD style="TEXT-ALIGN: right">64191</TD><TD>CHK</TD><TD style="TEXT-ALIGN: right">500</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1010465</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="TEXT-ALIGN: right">11/6/2002</TD><TD style="TEXT-ALIGN: right">1/24/2011</TD><TD style="TEXT-ALIGN: right">64191</TD><TD>CHK</TD><TD style="TEXT-ALIGN: right">500</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1010465</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="TEXT-ALIGN: right">11/13/2002</TD><TD style="TEXT-ALIGN: right">9/21/2010</TD><TD style="TEXT-ALIGN: right">64945</TD><TD>CHK</TD><TD style="TEXT-ALIGN: right">6172.62</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1010328</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="TEXT-ALIGN: right">11/5/2003</TD><TD style="TEXT-ALIGN: right">1/24/2011</TD><TD style="TEXT-ALIGN: right">81000</TD><TD>CHK</TD><TD style="TEXT-ALIGN: right">1000</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1010465</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="TEXT-ALIGN: right">11/5/2003</TD><TD style="TEXT-ALIGN: right">3/14/2011</TD><TD style="TEXT-ALIGN: right">81000</TD><TD>CHK</TD><TD style="TEXT-ALIGN: right">1000</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1010465</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="TEXT-ALIGN: right">11/5/2003</TD><TD style="TEXT-ALIGN: right">5/17/2011</TD><TD style="TEXT-ALIGN: right">81000</TD><TD>CHK</TD><TD style="TEXT-ALIGN: right">2000</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1010465</TD></TR></TBODY></TABLE>
Click to expand...
Control+shift+enter, not just enter:
Rich (BB code): 
=SUM(IF(FREQUENCY(IF($H$18:$H$26<>"",IF($A$18:$A$26>=B4,
  IF($A$18:$A$26<=C4,IF($B$18:$B$26>=B4,IF($B$18:$B$26<=C4,
   MATCH($H$18:$H$26,$H$18:$H$26,0)))))),
    ROW($H$18:$H$26)-ROW($H$18)+1),1))
 
Upvote 0
Perfect! Thanks for taking the time to assist...
Alex
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Solved
Amend formula to count unique text in a range
Replies
3
Views
107
Fluff
Fluff
S
  • Solved
Formula =SUMIF for a sum range of the first 4 digits only in the cells
2 3
Replies
20
Views
792
awoohaw
awoohaw
D
  • Solved
Multiple IF condition for time values
Replies
2
Views
170
DarkoDeign2
D
G
  • Solved
Skins Game Conditional Formatting
2
Replies
16
Views
259
Peter_SSs
Peter_SSs
P
  • Solved
How to count all unique values based on another column
Replies
6
Views
171
Fluff
Fluff

Forum statistics

Threads
1,207,094
Messages
6,076,549
Members
446,212
Latest member
KJAYPAL200

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