Couting rows based on given data range

[navin]

Hi All,

I have a sheet which contains supplier details for whom invoices are
still open and are ageing:

Eg.

Supplier Valid Invoice Invoice Ageing (Days)
ABC Valid 1
ABC Valid 2
ABC Invalid 3
ABC Invalid 5
ABC Valid 6
ABC Valid 16
ABC Valid 19
ABC Valid 20
ABC Valid 7
ABC Valid 10
ABC Valid 11

I have to count the number of suppliers based on the ageing bucket
they fall into, 0 days, 1 days, 2-15 days etc and they should be valid
invoices. Is there a formula which can count number of suppliers based
on range of days. So if in need to count # of supplier between 2-15
days from above then formula should return value as 2.

Thank you in advance for the help.
Navin

 

[T. Valko]

from above then formula should return value as 2.

Are you sure about that? Which 2 are being counted?