AverageIF with OR in Macro

[aadeshgandhi]

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!

[aadeshgandhi]

As I am trying to get this to work, one other thing that I should point out is that the data I will be using for getting the averages would be from a list filtered based on the date. The data that you see in Sheet 1 is for 04/15/2013. When I wrote this formula
=AVERAGEIF(AH:AH,"x",AG:AG)

It gave me average for the entire range and not just the filtered data. I am attaching the orginial data as well in Sheet 2 of AverageIF.xlsx


Thanks,
Aadesh Gandhi.

[aadeshgandhi]

I got it to work, used another logic to get around!




Aadesh.