Hi,
I'm hoping that there's a way to do this.
I'm trying to do a countifs formula where one of the criteria is in the column and from that column the data that I want to count is in that row.
So basically something like Countif(A:A,name,D1:AI,"LE"). I've attached an image of the sheet that I'm working on. Any help will be greatly appreciated
I'm hoping that there's a way to do this.
I'm trying to do a countifs formula where one of the criteria is in the column and from that column the data that I want to count is in that row.
So basically something like Countif(A:A,name,D1:AI,"LE"). I've attached an image of the sheet that I'm working on. Any help will be greatly appreciated