This is my formula:
=DCOUNT(timeg15w!$A$1:$F$3909, "WPC",Criteria!A1:C2)
My question concentrates on this part of the formula:...Criteria!A1:C2
When I drag down the formula, it changes, as usually, adding 1 to the cells address, like this:
Criteria!A1:C2
Criteria!A2:C3
Criteria!A3:C4
BUT, I want the formula dragged down, adding 2 instead of 1, changing like this:
Criteria!A1:C2
Criteria!A3:C4
Criteria!A5:C6
How can I achieve this result?
Bookmarks