sort column A by color first (not sure how), then select the B entries you need to average.
-
-
- Show replies
New conversation -
-
-
The best I can think would be to filter column a and enter a value into the cell. Then write an if statement based on that into a new column C. Finally run the average on column C. If you want you can make the text the same color as the fill to hide the value.
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
=SUMIF(A2:A,"Blue",B2:B)/COUNTIF(A2:A,"Blue")
- Show replies
New conversation -
-
-
use an countifs?
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
AverageIf(
-
=averageif(A:A,"Blue",B:B) something like this
End of conversation
New conversation -
-
-
Load data into R and use real code.
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.