I have a large amount of data that I am analyzing with specific criteria subsets. I originally thought I could utilize the averagifs function, but found that it cannot contain an OR element. I believe that an array might be the right path, but am having trouble getting it sorted correctly.
I have two columns in my data that I am using to identify data sets with (these two sets identify a location in a grid of data), an x and y coordinate you could say.
I am hoping to select one "x" value and TWO "y" values to include in the average calculation. eg: Calculate the average for all "x=2" AND "y=2 or 3".
Appreciate the guidance.
Bookmarks