View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
joromajr joromajr is offline
external usenet poster
 
Posts: 30
Default Formula returnsas "1" even with nothing to solve for?


-- 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