Count in array

[fmoiduf]

Sir

I have two columns which is Beginning date and Ending date. I am doing calculation to find a number of days in between two days. Some of them are "0 ", some of them are above "1" and some of them are "-1 ".

I wish to get the result directly to corresponding cells of the tables as per above description ( Blue color ).



File attached

[santoshmore25]

hello,

kindly check this formulas for same.

=COUNT(IF(DAYS($A$1:$A$11,$B$1:$B$11)<0,1)) for -1.

=COUNT(IF(DAYS($A$1:$A$11,$B$1:$B$11)=0,1)) for 0.
=COUNT(IF(DAYS($A$1:$A$11,$B$1:$B$11)>=1,1)) for 1.
please use Ctrl+Shift+Enter

[samba_ravi]

G3=sumproduct((int(b1:b11)-int(a1:a11)<0)+0)
g4=sumproduct((int(b1:b11)-int(a1:a11)=0)+0)
g5=sumproduct((int(b1:b11)-int(a1:a11)>0)+0)