I found the following formula online, which allows me to calculate average of data from another closed workbook.
=sumproduct(--('[Ty stats.xlsx]Averages'!$A$2$:$A$61="Qualifying"),'[Ty stats.xlsx]Averages'!F2:F61)/sumproduct(--('[Ty stats.xlsx]Averages'!$A$2$:$A$61="Qualifying"))
"Basically, if anything in the A column on the Averages sheet in Ty's book says "Qualifying", I want to take the Average of the F column. It's not too complicated, I just want it to work when Ty's workbook is closed"
The formula works great for one conditional variable. Is it possible to modify this formula to work with 2 or more conditional variables? i.e. if anything in column A says "Qualifying" and if anything in column B says "Red", then average of the F column
Bookmarks