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
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