Hello,
I am using the formula AVERAGEIFS to find an average of numerous column of numbers, but I want to have two different average results; 1) Criteria:24,Normal, 75Hz,1. 2) Criteria: 24,Normal,75Hz, Here I want to add a criteria of blanks). In my data some cells have "1" as the value and some are blanks as, hence I want to find the results to both kinds. The formula I used for the former is =AVERAGEIFS(L24:L234,A24:A234,24,B24:B234,"normal",G24:G234,"75hz",I24:I234,1) and it seemed to work, but the problem is the latter condition which I want to include blank cells as a criteria.

Thank you for reading through.