Excel 2007 : Counting multiple periods - presenting results at the end of each one

Hi everyone,

We have a column with multiple groups of numbers which are representing periods.
Between these periods we have blank cells. Every group has its own number.
We need a formula to count the numbers which appear in one column and show the results at the next one, presenting at the end of each period the results of the counting.

In the attached file you'll find a small but clear example.

Any help would be greatly appreciated !!!

hi spiro63, your last number before the 0 should be 5 right? you can try this

Please Login or Register  to view this content.

after pasting the formula in the formula bar, press CTRL + SHIFT + ENTER

Or simpler and not Array formula, but 1 helper column..

Thanks a lot guys,

Both solutions worked perfectly

P.s. : @ benishiryo you were right.
The last counted number was 5 not 7.
I apologize