I cannot figure out why this formula keeps telling me "There is a problem with this formula"
=COUNTIF('IMAC-D Summary'!E:E="Disposal", 'IMAC-D Summary'!Z:Z=Sheet5!E:E=Sheet5!E2)
I am trying to count the number of times that two conditions are met
1 - the word "Disposal" exists in column E of the IMAC-D Summary worksheet
and
2 - The value in cell E2 of the Sheet5 worksheet is present in column Z of the IMAC-D Summary
=COUNTIF('IMAC-D Summary'!E:E="Disposal", 'IMAC-D Summary'!Z:Z=Sheet5!E:E=Sheet5!E2)
I am trying to count the number of times that two conditions are met
1 - the word "Disposal" exists in column E of the IMAC-D Summary worksheet
and
2 - The value in cell E2 of the Sheet5 worksheet is present in column Z of the IMAC-D Summary