Hi,
I'm looking to count all the "Failure of Mobilising Equipment" for each month. I've made the data into a table (Table1), so it'll auto expand when new entries are added.
The reason column is also a Named list (Name Manager).
I've tried:
=COUNTIFS(Table1,">=01/01/2020",Table1,"<=31/01/2020",Table1,"=[@Reason]")
But it comes up as 0, when it should be 2. Even adding & doesn't give the correct answer. At the moment I've just got it counting for dates without the "Failure of Mobilising Equipment".
Any suggestions?
Dave
I'm looking to count all the "Failure of Mobilising Equipment" for each month. I've made the data into a table (Table1), so it'll auto expand when new entries are added.
The reason column is also a Named list (Name Manager).
I've tried:
=COUNTIFS(Table1,">=01/01/2020",Table1,"<=31/01/2020",Table1,"=[@Reason]")
But it comes up as 0, when it should be 2. Even adding & doesn't give the correct answer. At the moment I've just got it counting for dates without the "Failure of Mobilising Equipment".
Any suggestions?
Dave