Average IF : Formula issue

[chandrashekar]

Hello,

Could you please help me on average formula. If I use average if formula am getting different value
(1st screenshot am getting 24.00 and second screenshot getting 27.42). May I know where is going in calculation
Formula using: =AVERAGEIFS(Sheet3!AX:AX,Sheet3!G:G,"AGC")

 

[awoohaw]

your images only select 4 rows of data, but your formula selects entire columns. it is hard to know if you have data above or below in your image range.
my guess is that you have data in either of the columns that affects the calculation.

Also where is the column with AGC in your image?

What happens if you only use those rows in the formula?

=AVERAGEIFS(Sheet3!AX4:AX7,Sheet3!G4:G7,"AGC")

 

[chandrashekar]

your images only select 4 rows of data, but your formula selects entire columns. it is hard to know if you have data above or below in your image range.
my guess is that you have data in either of the columns that affects the calculation.

Also where is the column with AGC in your image?

What happens if you only use those rows in the formula?

=AVERAGEIFS(Sheet3!AX4:AX7,Sheet3!G4:G7,"AGC")

Hello,

I tried fixing range but getting same result.

Regards,
Chandrashekar B