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?
-
-
No problem
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.