SUMIFS Values from non consecutive Column Cells -

i need tu sum several cells separated 1 another, these cells

c3,f3,i3,l3,o3,r3,u3,x3,aa3,ad3,ag3,aj3,am3,ap3,as3,av3,ay3,bb3,be3,bh3,bk3,bn3,bq3,bt3,bw3,bz3,cc3,cf3,ci3,cl3,co3

if other cells $c$1,$f$1,$i$1,$l$1,$o$1,$r$1,$u$1,$x$1,$aa$1,$ad$1,$ag$1,$aj$1,$am$1,$ap$1,$as$1,$av$1,$ay$1,$bb$1,$be$1,$bh$1,$bk$1,$bn$1,$bq$1,$bt$1,$bw$1,$bz$1,$cc$1,$cf$1,$ci$1,$cl$1,$co$1

that on same column different row >= number given , <= other given number, returns #value, can me find out doing wrong?

this function writing:

=sumifs((c3,f3,i3,l3,o3,r3,u3,x3,aa3,ad3,ag3,aj3,am3,ap3,as3,av3,ay3,bb3,be3,bh3,bk3,bn3,bq3,bt3,bw3,bz3,cc3,cf3,ci3,cl3,co3),($c$1,$f$1,$i$1,$l$1,$o$1,$r$1,$u$1,$x$1,$aa$1,$ad$1,$ag$1,$aj$1,$am$1,$ap$1,$as$1,$av$1,$ay$1,$bb$1,$be$1,$bh$1,$bk$1,$bn$1,$bq$1,$bt$1,$bw$1,$bz$1,$cc$1,$cf$1,$ci$1,$cl$1,$co$1),">="&b55,($c$1,$f$1,$i$1,$l$1,$o$1,$r$1,$u$1,$x$1,$aa$1,$ad$1,$ag$1,$aj$1,$am$1,$ap$1,$as$1,$av$1,$ay$1,$bb$1,$be$1,$bh$1,$bk$1,$bn$1,$bq$1,$bt$1,$bw$1,$bz$1,$cc$1,$cf$1,$ci$1,$cl$1,$co$1),"<="&c55)

i'm not 100% certain, looks problem here sumifs requires arguments expressed in continuous-range form, e.g. a3:co3. looks you're trying work every third column in dataset, yes? far can tell, best (only?) done array function, can tell filter on "every third column."

enter in cell, press ctrl+shift+enter (cse) evaluate array function:

=sum(($a$1:$co$1>=b55)*($a$1:$co$1<=c55)*(mod(column(a3:co3),3)=0)*(a3:co3))

you'll need hit cse every time evaluate or change it. there's decent tutorial array functions @ https://support.office.com/en-za/article/guidelines-and-examples-of-array-formulas-7d94a64e-3ff3-4686-9372-ecfd5caa57c7, may if you're unfamiliar them.