Average content distributed in more than one column
Hi, is there a way to get AVEFAGE from cells belonging to different columns? The formula AVERAGEIF only targets one column.
I know that usually I could SUM both columns and then divide with the COUNT of cells there are to get it, but the problem is that I only want to include cells that have a certain text in another column. SUMIF works well but then COUNTIF seems to be autoreferential, so I can't count the cells that have that value in this other column.
Is there an easy way to get this? Getting an AVERAGEIF of both columns and then averaging that result doesn't work because it distorts the result by averaging an average, plus if cells in one column are blank you get an error.