Excel: Count empty blank cells betwen numbers - Help Please

Hi Can someone please help me.. I have been asked to create a spreadsheet and part of it counts the number of empty cells between the numbers.. Example below On the first row these numbers are copied in from another sheet then row 4 is where I need the formula. There are many columns so once I have the formula then I can drag across but it gives you he idea of what I want Thanks Shaun

1 2 5 1
2 1 3

This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of November 20, 2014.

For more resources for Microsoft Excel