Mar 16 2021 12:53 PM
I am trying to make the following code not average blank spaces. Please help
=AVERAGEIF(F2:F79,VLOOKUP(F2,F2:G79,{1,2},FALSE),G2:G79)
Mar 16 2021 02:57 PM
What do you mean by "blank spaces"?
Either empty cells or cells with a space in them?
In any case AVERAGEIF() ignores empty cells and text.
Mar 17 2021 06:22 AM
Mar 17 2021 07:40 AM
SolutionThat's how every average function works. You need at least one number value to calculate an average.
You can wrap IFERROR( ) around your formula to show a message or a 0.
=IFERROR(your_formula;"no values")
Mar 17 2021 07:40 AM
SolutionThat's how every average function works. You need at least one number value to calculate an average.
You can wrap IFERROR( ) around your formula to show a message or a 0.
=IFERROR(your_formula;"no values")