I am looking to take an Average of all the cells in column B that have "Test" as a value for column A.

Something like if(A:A = "Test",Average(B:B))