Forum Discussion
Count the value
Hi I have an excel sheet in which money is written but I want that whenever I total money, it should give me a blank row as soon as it is 1000 in each total like the total of the data I have is 5000....
any body have no reply regarding this
Manish_Ojha so I did a couple of options because I wasn't sure what you need exactly:
each of the columns E:I are based on the values in A and column C is just for reference.
columns E&F use array formulas while H&I use old style formulas that you copy/fill down
in each case I show value if the cumulative total crosses the thousands mark. I think this is what you wanted. If not please explain a little better.