Hey people!
Is it possible to COUNTIFS Column C contains "Y" OR Column D contains "Y". Therefore COUNT should = 2
Is it possible to also AVERAGEIFS the Age if Column C OR Column D contains Y? Therefore average should = 37.5.
I have a spreadsheet that contains thousands of rows and hundreds of columns so I usually select my columns in formulas like this: $C:$C vs $C$2:$C$35
Bookmarks