#value error in averageifs formula

[andrugrasu]

ok. in the sheet "baza" in cell q5 i have a formula wich use averageifs function and its work.
when a try to put formula in the sheet "Sheet 1" (cell g10) and refer to column I from sheet "baza" formula dont work and i have VALUE error. i dont understant why.
Some help.....

[daddylonglegs]

All the criteria ranges need to be the same size with AVERAGEIFS, otherwise you get #VALUE! error

[andrugrasu]

All the criteria ranges need to be the same size with AVERAGEIFS, otherwise you get #VALUE! error

i get the same error if i make the ranges equals

[daddylonglegs]

Changing the formula to make the ranges the same size, i.e. this version

=AVERAGEIFS(baza!I4:I214,A4:A214,"="&A4,A4:A214,"="&A4)

....gets rid of #VALUE! error but I get #DIV/0! error because there is nothing to average

Can you explain what you are trying to do?

You are using the same criteria twice?

Are the ranges supposed to be on sheet1 or baza?

[andrugrasu]

Changing the formula to make the ranges the same size, i.e. this version

=AVERAGEIFS(baza!I4:I214,A4:A214,"="&A4,A4:A214,"="&A4)

....gets rid of #VALUE! error but I get #DIV/0! error because there is nothing to average

Can you explain what you are trying to do?

You are using the same criteria twice?

Are the ranges supposed to be on sheet1 or baza?

what i want to do is this: calculate the average from sheet baza (range from column I) in sheet "Sheet1" but with calendaristic date from it. ex: for 01.09.2017 from "Sheet1" i want to calculate average for this date.the date for average are in column I sheet baza.

[daddylonglegs]

Try this formula

=AVERAGEIFS(baza!I:I,baza!A:A,A4)

[Glenn Kennedy]

Your layout is maybe a bit confusing, but is this it??