I use the following array-formula to calculate a conditional average:

=AVERAGE(IF(MONTH('Veje'!$G$5:$G$150)&YEAR('Veje'! $G$5:$G$150)=MONTH(B4)&YEAR(B4),'Veje'!$J$5:$J$150 ))

and it works perfectly OK.

My problem is, that I need to add another condition or rather two as the numbers uin H5:H150 need to be between 77 and 119 if the number in column J shall be included in the avarage.

The list in 'Veje"' contains dates in the G-column, numbers in the H-column, and numbers in the J-column.

In Sheet Avagerage, I have months and years in the B-column. What I want to achieve is to calculate the average per month of the numbers in the J-column (first condition: year and month of dates Veje!J.. must be equal to year and month in the B-colum of Average. Numbers in Veje!J shall only be calculated if respective values in Veje!H is between 77 and 119

I have tried with different combinations of AND, but spo far with nmo success.

Any suggestions if understandable at all?

Jan