Hi Shane,
In the formula below you still is considering a # or rows i.e. N5000, what
if the rows go beyong that point

"Shane Devenshire" wrote:

Hi,

If there are no spaces before the last entry you can use

=-SUMPRODUCT(--(OFFSET(N7,0,0,COUNTA(N7:N5000))<0),--(OFFSET(BA7,0,0,COUNTA(BA7:BA5000))<"BD"),--(OFFSET(N7,0,0,COUNTA(N7:N5000))))

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Eduardo" wrote in message
...
Hi All, and thanks in advance
I am using the formula as follow and I wonder if there is any way to make
it
work when the range is variable
=-SUMPRODUCT(--(N7:N1000<0),--(BA7:BA1000<"BD"),--(N7:N1000))

Any help really appreciate