Re: [libreoffice-users] Re: Fwd: Need a count formula for calc

2015-11-08 0:57 GMT+01:00 m.a.riosv : > I think for not take care of the number of blank cells, it's easier and > versatile with SUMPRODUCT() > > =SUMPRODUCT($A$2:$A$12>$B$2:$B$12;$A$2:$A$12>0;$B$2:$B$12>0) > What if negative numbers are used? > > Attached a

[libreoffice-users] Re: Fwd: Need a count formula for calc

I think for not take care of the number of blank cells, it's easier and versatile with SUMPRODUCT() =SUMPRODUCT($A$2:$A$12>$B$2:$B$12;$A$2:$A$12>0;$B$2:$B$12>0) Attached a sample file. Miguel Ángel. -- View this message in context: