View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LaTanya LaTanya is offline
external usenet poster
 
Posts: 8
Default Countif Function w/ multiple Criteria

I am trying to count the occurances on the following labels in a row

LOA, TRN,VAC

I can only get 1 of the lable to return the number I need to added the other
2, this is the formula I used

=COUNTIF(K226:X226,"TRN")

But I need it to be something like this to return a value of 3
=COUNTIF(K226:X226,"TRN,VAC,LOA")

Active LOA Active Active Active Active Active Active Active Active Active TRN VAC Active