I am making a spreadsheet to score recipe ingredients, averaging scores for quality of the ingredient, packaging, and accuracy of serving size, and then using that data to create an average for the whole recipe.
The scores are filled in through data validation. 1=Bad, 2=Fair, 3=Good. The AVERAGE
formula works fine when all of the fields are input through the dropdowns, but if any of the rows are left with all blank values I get a DIV/0
error in the column I am attempting to get average in (E8:E19
) as well as the average for the entire recipe (B20
). I tried to do AVERAGEIF
, but that didn't work and I am stumped. Every recipe has a different number of ingredients, so it is important that this function works whether I have one ingredient or 20.
I tried to upload a screenshot but the site won't let me.
AVERAGEIF