Like I said before, that worked great. Now, is it possible to reture a value
from a cell?
=sumproduct(--(j19:j303),--(j19:j30<7),E5)

"bj" wrote:

try
=sumproduct(--(j19:j303),--(j19:j30<7))
the "--(" converts the logic true or false to a numeric 1 or 0

"pgarcia" wrote:

This is what I typed but got the "#Value!" message.
=SUMPRODUCT(AND(J19:J303,J19:J30<7))

"pgarcia" wrote:

This is what I have now, =COUNTIF(J19:J31,"= 2")but how do I do the same
for it but like this?
=IF(AND(J2=2,J2<120),Q2,0)

=COUNTIF(and(J19:J31,"= 2",J19:J31"<7")) does not work?