All ranges must be in equal size. The first range is A1:A6 & others are from 2nd row.
=AVERAGE(IF(A2:A6="A",IF(B2:B6="123",C2:C6)))
Change A1:A6 to A2:A6
Also, for the numbers if you are using REAL numbers remove quotes between the number ("123") just use =123
Bookmarks