I have 42 rows of data and I need to average every 3rd row if "1". I've
tried a couple formulas:

1.
averageif(D6,G6,J6,M6,P6,S6,V6,Y6,AB6,AE6,AH6,AK6, AN6,AQ6,"1",D6,G6,J6,M6,P6,S6,V6,Y6,AB6,AE6,AH6,A K6,AN6,AQ6)

I get #VALUE.

2.
=SUM(SUMIF(INDIRECT(D6,G6,J6,M6,P6,S6,V6,Y6,AB6,AE 6,AH6,AK6,AN6,AQ6),"1"))/SUM(COUNTIF(INDIRECT(D6,G6,J6,M6,P6,S6,V6,Y6,AB6,A E6,AH6,AK6,AN6,AQ6),€�1€�))

The error window shows too few arguments. I found #2 on this website.

Your help would be greatly appreciated.

TC Thanks