I have the following issue with COUNTIF

[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

 

[Peo Sjoblom]

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

 

[FSt1]

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