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