I have the following issue with COUNTIF
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
|