I'm going to pull my hair out...
See attached file. I've validated that AVERAGE and IF work as expected for the range, but I am going crazy trying to figure out why the AVERAGEIF just won't cooperate.
Please tell me what stupid thing I'm overlooking doing wrong.
Bookmarks