View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_3_] Peo Sjoblom[_3_] is offline
external usenet poster
 
Posts: 136
Default 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