View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
al al is offline
external usenet poster
 
Posts: 64
Default Count every group of numbers whose sum is zero & put formula next toeach number

I have the following numbers in column A
1
2
3
-2
-4
5
5
-10
3
3
-6

I need a formula in column B next to each number telling me to which
group of sum zero it belows i.e

1,2,3,-2,-4 would each have number 1 next to each of them in column B
(first group of sum zero)

5,5,-10 would each have number 2 next each of them in column B (second
group of sum zero)

3,3,-6 would each have number 3 next to each of them in column B
(third group of sun zero)

Pls help thxs