Thread: Formula to compute value based on Ageing

1. Formula to compute value based on Ageing

I have values in Col W and the age of the item in Col AB

I would a formula to compute the value in Col W based on the ageing in Col AB as follows

0-30
31-60
61-90
91-120
>120

Your assistance in this regard is most appreciated

=AVERAGEIFS('Imported Data'!\$W\$2:\$W\$243,'Imported Data'!\$AB\$2:\$AB\$243,">=0",'Imported Data'!\$AB\$2:\$AB\$243,"<=30")
=AVERAGEIFS('Imported Data'!\$W\$2:\$W\$243,'Imported Data'!\$AB\$2:\$AB\$243,">30",'Imported Data'!\$AB\$2:\$AB\$243,"<=60")
=AVERAGEIFS('Imported Data'!\$W\$2:\$W\$243,'Imported Data'!\$AB\$2:\$AB\$243,">60",'Imported Data'!\$AB\$2:\$AB\$243,"<=90")
=AVERAGEIFS('Imported Data'!\$W\$2:\$W\$243,'Imported Data'!\$AB\$2:\$AB\$243,">90",'Imported Data'!\$AB\$2:\$AB\$243,"<=120")
=AVERAGEIFS('Imported Data'!\$W\$2:\$W\$243,'Imported Data'!\$AB\$2:\$AB\$243,">120")

Steve

3. Hi Steve

Thanks for the help. However, I amended your formula to use SUMIFS

Howard

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•