i just saw a post where the op used
=COUNTIF(A$1:A$4,"<=0")*AND(COUNTIF(B$1:B$4,">=0"))
to count on 2 criteria. and sad to say i cant see how it works!
i'd use
=SUMPRODUCT((A1:A4<=0)*(B1:B4>=0)) to do the same.
its the use of the "and" thats thrown me whats the logic behind it.?
Bookmarks