View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Johndb Johndb is offline
external usenet poster
 
Posts: 16
Default countif comparing two columns

Please help.

I have two colums of data I need to compare, roughly 100 rows each. I need
to count a given row if the value in column b is greater than the number in
column a. There are a few alpha letters in each row. I have scoured and
tested everything I have seen posted regarding countif, sumif, sumproduct,
etc. and I can't seem to get it to work. Any assistance would be greatly
appreciated.

Thanks in advance,

John