Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |