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