Needing some help to figure out this formula.
I am using COUNTIF currently of this =COUNTIFS(AF:AF,T6,AT:AT,">0") to find # of 0-1 values in columns. This certain part of my sheet uses a different setup. This particular one gives a certain # but on say half of the entries. I need a max value formula to search the same criteria in the countif but find the max value associated with T6 from AF:AF in AT:AT??
THANKS!
I am using COUNTIF currently of this =COUNTIFS(AF:AF,T6,AT:AT,">0") to find # of 0-1 values in columns. This certain part of my sheet uses a different setup. This particular one gives a certain # but on say half of the entries. I need a max value formula to search the same criteria in the countif but find the max value associated with T6 from AF:AF in AT:AT??
THANKS!