I have basic to medium knowledge in Excel, and I am having trouble with a somewhat complicated problem for me.
I have a table where I need to relate three columns: a "Type" column, and another two with numeric values, which I need to divide by one.
The problem is: I would like to perform this calculation only for rows that have a certain "Type", and then average the results. Something like the image linked below.
I know more or less how logic should work. I tried using the "Format as Table" function and using the "IF" function with the column name, something like IF (Sheet1 [Type] = "A"; Sheet1 [Data 2] / Sheet1 [Data 1]; "NA "), but I think that's not how it works.
I also tried the VLOOKUP function, but I couldn't think straight out how I could average the values later.
Thank you for your help.
The result would be something like this, but for a very large table it would be impracticable to do so.
=SUMPRODUCT((A$2:A$12=E2)*(C$2:C$12/B$2:B$12))/COUNTIF(A$2:A$12;E2)
should do it.