View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rebekah Rebekah is offline
external usenet poster
 
Posts: 20
Default COUNT function... I think!

I have two colomns of data, I need to operate the count function only if the
data in both colomns, within the same row are true i.e

I need to count the how many times the trade "car" happens to be a priority
"2".

Trade Priority
CAR 2
BRI 2
ROO 2a
ELE 2a
PLU 3
CAR 2

I have tried to use =COUNTIF, =COUNT(IF

Is this possible and what is the correct formula/function to use?