Did you miss a couple of ()'s when you typed this post?

I guessing your formula looks more like:

=COUNT((P2-H2J2)+(S2-H2J2)+(V2-H2J2)+(Y2-H2J2)+(AB2-H2J2)+
(AE2-H2J2)+(AH2-H2J2)+(AK2-H2J2)+(AN2-H2J2)+(AQ2-H2J2)+
(AT2-H2J2)+(AW2-H2J2)+(AZ2-H2J2)+(BC2-H2J2)+(BF2-H2J2)+
(BI2-H2J2)+(BL2-H2J2)+(BO2-H2J2)+(BR2-H2J2)+(BU2-H2J2)+
(BX2-H2J2)+(CA2-H2J2)+(CD2-H265)+(CG2-H2J2))

All those expressions are returning numbers--but you're adding them into a
single number.

=count(1+0+1+0+1+1+1)
returns 1.

I'm guessing that you don't want the equivalent of:
=count(1,0,1,0,1,1,1)
since it would count the 0's as well as the 1's.

I think you'll want to drop the =count() function and just add those numbers
that evaluate to true/false (1's/0's).

(P2-H2J2)+(S2-H2J2)+(V2-H2J2)+(Y2-H2J2)+(AB2-H2J2)+
(AE2-H2J2)+(AH2-H2J2)+(AK2-H2J2)+(AN2-H2J2)+(AQ2-H2J2)+
(AT2-H2J2)+(AW2-H2J2)+(AZ2-H2J2)+(BC2-H2J2)+(BF2-H2J2)+
(BI2-H2J2)+(BL2-H2J2)+(BO2-H2J2)+(BR2-H2J2)+(BU2-H2J2)+
(BX2-H2J2)+(CA2-H2J2)+(CD2-H265)+(CG2-H2J2)

ps. Why is this in your formula:

+(CD2-H265)+

It looks out of place.

joromajr wrote:

-- Question--

I used the count function to determine the number of time check dates go
beyond term limit. I have not even encoded check dates already cell returns
"1"?

"=COUNT(P2-H2J2)+(S2-H2J2)+(V2-H2J2)+(Y2-H2J2)+(AB2-H2J2)+
(AE2-H2J2)+(AH2-H2J2)+(AK2-H2J2)+(AN2-H2J2)+(AQ2-H2J2)+
(AT2-H2J2)+(AW2-H2J2)+(AZ2-H2J2)+(BC2-H2J2)+(BF2-H2J2)+
(BI2-H2J2)+(BL2-H2J2)+(BO2-H2J2)+(BR2-H2J2)+(BU2-H2J2)+
(BX2-H2J2)+(CA2-H2J2)+(CD2-H265)+(CG2-H2J2)"

Whe
H2 is invoice date
J2 is term limit
joromajr

--

Dave Peterson