Hello,
I have been trying to get this formula to work which I expected to be straightforward but for some reason I am not able to do so. The logic is to return the average of values in column A if column B has a certain value. Please see attached sheet, I want two averages;
one when value in column B is either X or A
and other when value is B or Z.
Also how to write a macro for this?
Thanks,
Aadesh!
Bookmarks