How to add elements of the same columns under such condition?
Solution 1:
Do other cells in column C (Such as C12, C13 ) have content?
If not, please try the formula =IF(MOD(ROW(),10)=1,INDIRECT("A"&(INT(ROW()/10)-1)*20+11)+INDIRECT("A"&(INT(ROW()/10)-1)*20+21),"")
in C11, and then drop down.