I have the following issue with COUNTIF

  • Thread starter Thread starter Fab
  • Start date Start date
F

Fab

Okay I have a consolidated workbook - I need to refer to a column in another
workbook and count what type that cell is ie: RSW, LCQ etc

Thats the easy part.

In the result cell I also need to refer to the colmun next to the RSW and
find out how many of those RSW's are 500 or under.

Please help
 
Try this


=SUMPRODUCT(--(A2:A100="RSW"),--(B2:B100<=500))

If there cannot be any blanks where A is RSW, if there cab be blanks you can
add



=SUMPRODUCT(--(A2:A100="RSW"),--(B2:B100<=500),--(ISNUMBER(B2:B100)))



replace A2:A100 with your real range and sheet name and the same with
B2:B100


--


Regards,


Peo Sjoblom
 
Back
Top