Hello,
I am trying to obtain the average of cells in a column. The cells in the column need to be averaged only if they contain "w_" or "wd_".
Below is the formula I am trying:
=AVERAGEIFS('All Data'!S:S, 'All Data'!B:B,"w_*", 'All Data'!B:B,"wd_*")
I keep getting a #DIV/0! error.
This...