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


"Fab" wrote in message
...
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

hi,
maybe countif may not be what you need. try this
=SUMPRODUCT((A2:A20="RSW")*(B2:B20<500))

adjust ranges and values to suit.
see this site for more info on sumproduct
http://www.xldynamic.com/source/xld.SUMPRODUCT.html#new

regards
FSt1

"Fab" wrote:

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