How can ignore some cells when I drag my formula down?

[cabbage]

Kinda refreshing my very basic Excel knowledge.

I have two tables on excel one underneath the other with a gap of two rows in between them.

I am using this formula -='Data - Headcount'!$L5/'Data - Headcount'!$C5 in column C and have successfully managed to drag it down to other cells in the column. However, I would like to drag the same formula down in to the second table, excluding or by passing the gap of two empty rows.

I hope this makes sense...anyone able to help?

 

[jtakw]

Hi,

You can do something like:

=IF(A5="","",your formula)

then when the formula is dragged down thru the Empty rows, it'll just stay blank.