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?
-
-
-
Replying to @digitrev @Aella_Girl1 reply 0 retweets 1 like
-
Replying to @digitrev
this is giving me div/0 error in my own sheet but maybe im sleep deprived
1 reply 0 retweets 0 likes -
-
Replying to @digitrev @Aella_Girl
Or possibly extra characters at the end.
1 reply 0 retweets 0 likes
Replying to @digitrev
im gonna pass out now but will retry tomorrow, thank you!
5:24 PM - 27 Nov 2017
0 replies
0 retweets
1 like
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.