Hello, I am trying to calculate an average of 2 columns.
I want the yellow colums averaged on 3 criteria ranges - pink, orange and red if in those ranges there is written concrete text.
Here is a picture of what I'm trying to do. excel.jpg
Thanks in advance.
Bookmarks