Hi all,
Just wondering if you knew a way to add specifics into a countif. I currently have this...
=COUNTIF(Sheet1!D8:AC8,">=4")
But I also need to know if the ">=4" is within specific columns. So lets say H8 and P8 must have ">=4" and if they do "yes" if they don't "no"
Cheers,
Paul
Bookmarks