Thread: How do I do the same for this formula?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default How do I do the same for this formula?
With more than one criteria, it is easier to use SUMPRODUCT()
--
Gary''s Student
gsnu200710


"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