Couting rows based on given data range

  • Thread starter Thread starter navin
  • Start date Start date
N

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
 
from above then formula should return value as 2.

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