creditcontrol

  1. P

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

    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...
    • Petervz
    • Thread
    • ageing countif filtered creditcontrol reporting sumproduct countif
    • Replies: 13
    • Forum: Excel Questions

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