# Formula required to make Aging Sheet

1. ## Formula required to make Aging Sheet

Hello All,

I am using Excel 2013 and need a formula to calculate ageing of various equipment installed in different plants

I have made a sample for my problem which is attached herewith

I need a formula in C10, E10 and G10 which I can drag down to fill up the values

C10 - should count the Equipment from A2 till down and compare each equipment with the year in C2 till down and match the year with Period in B10 till down

E10 - should increment by the count of Eq in respective years

G10 - will sum the values for respective year comparing it with the Period

Sample data is small actual data will be much more

I have given some explanation next to each cell where the formula is required

Cells colored for explanation purpose only.

Hope to get some help
TIA
Sameer

2. ## Re: Formula required to make Aging Sheet

C10
=COUNTIF(\$C\$2:\$C\$6,"<"&DATE(B10+1,1,1))

Not sure why your sample increment by 2 on E10 to E11
E11
=E10+C11

G10
=SUMIFS(G\$2:G\$6,\$C\$2:\$C\$6,"<"&DATE(\$B10+1,1,1))

3. ## Re: Formula required to make Aging Sheet

Dear Ray
I will test with my actual data and revert

4. Originally Posted by sameer79
Dear Ray
I will test with my actual data and revert
Dear Ray

It works perfectly.
Thanks for your help and time

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1