Google Sheets question - say I have two columns, A (consisting of 'blue' and 'red' entries) and column B (consisting of numbers).
How do I calculate average of Column B ("=average (B2:B)") but filtering only to count numbers corresponding to 'Blue' in A?
