Averageif across multiple columns

[Tleuthe]

I have the months of the year listed in columns. Under each month I have a reported lab value. I would like to average the lab values over the months, however, I only want to average them if the value in column cell A is equal to "Y". The formula will only show the value listed in the first month and will not average across the months. If I do a simple average across the months it averages fine, but not using AVERAGEIF function. Is this a limitation of the function across columns? The formula I am using is: =IFERROR(AVERAGEIF(A2, "Y", B2:M2), ""). The "IF" part seems to be working, just won't average.

[FDibbins]

Hi, welcome to the forum

if all you are doing, is testing to see if A contains Y, then why not just...
=IF(A2="y",AVERAGE(B2:M2),"")

The way you are doing it, it is ONLY looking ar B2 for the avg

[shukla.ankur281190]

Try

N2

=IF(A2="Y",AVERAGE(B2:M2),"")

[Tleuthe]

Thank you so much! That works perfectly. Self learning is painful! I spent hours trying to figure this out. This makes more sense.