Thread: How do I do the same for this formula?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
pgarcia pgarcia is offline
external usenet poster
  
Posts: 304
Default How do I do the same for this formula?
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?
Reply With QuoteReply With Quote