One way ..
Put in R7:
=IF(C7="","",IF(C7<TODAY()-90,">90",IF(AND(C7>=TODAY()-90,C7<TODAY()-60),">=90-60",IF(AND(C7>=TODAY()-60,C7<TODAY()-30),">=60-30",IF(C7>=TODAY()-30,"<30","")))))
Copy R7 down to R200. R7:R200 will return all the various aging labels that
you could then use in sumproduct formulas as desired, for eg:
=SUMPRODUCT(($R$7:$R$200=">=60-30")*$Q7:$Q200)
returns the total of amounts in col Q for dates in col C within 30-60 days old
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---