Hi Everyone,

This is my formula:

=SUMPRODUCT(INDEX('Report'!$D$6:$O$28*(MOD(ROW('Report'!$D$6:$O$28),2)),0,MATCH(BULK$C$10,months,0)))

So the above formula sums every other row within the range in the column i choose. I choose the column by inputing my column choice in cell C10 in tab BULK.

Now some cells in the range include text that I would like to exclude when i sum so I dont get a #Value!

Can anyone help please?

Thanks,