Sum of invoices in a filter, counting only visible invoices per aging group.

[Petervz]

Data :
Payor Payor Name Client Client Name Matter Matter Name Bill Date Bill Number Outstanding A/R Aging
51234 Payor1 41234 Client 11 12345678 Mr Excel 16-09-14 87654321 € 1.000,00 400
51235 Payor2 41235 Client 12 12345679 Mr Excel 20-10-14 87654322 € 2.000,00 366
51236 Payor3 41236 Client 13 12345680 Mr Excel 04-04-15 87654323 € 3.000,00 200
51237 Payor4 41237 Client 14 12345681 Mr Excel 05-04-15 87654324 € 4.000,00 199
51238 Payor5 41238 Client 15 12345682 Mr Excel 18-05-15 87654325 € 5.000,00 156
51239 Payor6 41239 Client 16 12345683 Mr Excel 05-06-15 87654326 € 6.000,00 138
51240 Payor7 41240 Client 17 12345684 Mr Excel 15-07-15 87654327 € 7.000,00 98
51241 Payor8 41241 Client 18 12345685 Mr Excel 20-08-15 87654328 € 8.000,00 62
51242 Payor9 41242 Client 19 12345686 Mr Excel 21-08-15 87654329 € 9.000,00 61
51243 Payor10 41243 Client 20 12345687 Mr Excel 05-09-15 87654330 € 10.000,00 46
51244 Payor11 41244 Client 21 12345688 Mr Excel 07-10-15 87654331 € 11.000,00 14
51245 Payor12 41245 Client 22 12345689 Mr Excel 15-10-15 87654332 € 12.000,00 6

Count of visible invoices : Formula =SUBTOTAL(3;H10:H10000)
Sum of visible invoices : Formula =SUBTOTAL(9;I10:I10000)
Avg of ageing visible invoices : Formula =SUBTOTAL(1;J10:J10000)

As i now want to calculate how many (visible) invoices are 361+ , 180-360 and so on.
I tried MrExcel's Learn Excel #946 - Countif Filtered but i couldn't get it right. Nor i succeeded with Sumproduct

Using Microsoft Excel 2010

I am a Credit Control Specialist and would like to make a good reporting sheet. Thank you for your input in this !!

 

[Petervz]

 

[Petervz]

Sorry, had some difficulties with my picture :

 

[Petervz]

 

[Petervz]

Is there anyone who could help me out on this puzzle?

 

[Aladin Akyurek]

Is there anyone who could help me out on this puzzle?

An image is not helpful. In order to post an Excel readable, small sample, you might want to try instead one of the methods listed in the following: Attachments or using this add-in:https://app.box.com/s/soezox25h3w0q5s4rcyl.

 

[Petervz]

I am very limited on my workstation, so sorry for this inconvenience. Would anyone be able to help me out?

 

[Aladin Akyurek]

I am very limited on my workstation, so sorry for this inconvenience. Would anyone be able to help me out?

What is the aging range?

 

[Petervz]

361 and above, 181 to 360 and so on

 

[Aladin Akyurek]

361 and above, 181 to 360 and so on

I meant the cell range...