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?
this is giving me div/0 error in my own sheet but maybe im sleep deprived
-
-
Hm. Check case sensitivity?
-
Or possibly extra characters at the end.
- Show replies
New conversation -
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.