Dear experts,
I'm breaking my head over the COUNTIF formula.
I have an excel to track the replacement of computers. I want to have a count overview of the age of the computers.
In cell I1 I want to show the total count of all the computers younger than 3 years (< 3 years)
In cell I2 I want to show the total count of all the computers older than 3 years but younger than 4 years (>3year s <=4 years)
In cell I3 I want to show the total count of all the computers older than 4years.
In column B I mention the status: active, replace, defect, decom.
In column I is the date the computer was bought and in column J I have a formula showing the age in year and month:
If the status of the computer however is "decom", then I don't want that computer to be added to the count in I1:I3 and there' where I'm struggling.
In cell I1 I have following formula:
In cell I2 I have following formula:
In cell I3 I have following formula:
Cell Q1 has the current date minus 3 months.
Cell Q3 has the current date minus 4 months
Much appreciated,
Thanks and best regards,
Siegfried
aka Rvbicon
Bookmarks