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?
Conversation
Show replies
This Tweet is from a suspended account. Learn more
Show replies
Replying to
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.
