Cin,

Thank you for your efforts. I am not after the formula you sent. The
overdue amount should appear under these specific headings, picking from the
monthly invoice amounts starting from column E to AI.

I know it is not a simple job, otherwise I could have figured it out. I
need someone without a professional approach to help me.

I appreciate your sincerity to spend some time for me.

Regards,

Jaleel



"Cin" wrote:

Is this what you are after?

=IF(AM6=0, "Not Due", IF(AM6<30, "Overdue < 30 days", IF(AM6<60, "Overdue
30-60 days", IF(AM6<90, "Overdue 60-90 days", IF(AM6<121, "Overdue 90-100
days", IF(AM6120, "Overdue 120 days",""))))))

"Jaleel" wrote:

Don,

I have sent the file to you. Try your level best to find a solution, even
the giants are keeping silent.

Sincere Regards,

Jaleel

"Don Guillett" wrote:


You don't give enough info but try looking the help index for COUNTIF and
SUMIF
--
Don Guillett
SalesAid Software

"Jaleel" wrote in message
...
I have an Excel File with the range of A1:AR35. I need some formula in the
range AM6:AR35. The requirement is to get the results according to the
credit terms of the Clients like 30 days, 45 days, 60 days, 90 days and
whichever payment is overdue in the columns with the heading as follows:

Not Due "Overdue < 30 days" "Overdue30 - 60 days" "Overdue 60 - 90 days"
"Overdue 90 - 120 days" "Overdue 120 days"

It is a Client Position file, which I cannot describe through this. If
anybody can help me I can send the file through email. Please, it is
prestige issue.

Jaleel