Thanks for your funtion, but I want to count a number of the negative values.
How to calculate the pay-back time (poin) during the first positive value?
"Ashish Mathur" wrote:

Hi,

I assume that you actually want to add the negative values and positive
values seperately. To compute the sum of negative values and positive
values, use the sumif funtion.

Regards,





"Dmitry Kopnichev" wrote:

Hello
How to calculate a pay-back period by the accumulated cash-flow
automatically? How to count number of negative values in a row range? How to
count ratio of a first positive value to module of the last negative value
automatically?