View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Romileyrunner1 Romileyrunner1 is offline
external usenet poster
 
Posts: 73
Default Countif multiple items

HI,
How do I countif a range where I want it to include more than 1 item. I`m
usng the formula :
=COUNTIF(AN10:AN89,{"W","SA+","ST","SA"})

This isn`t working, it`s just counting up the first item, i.e. all the "W"
entries. How do I get it to count all the SA+, ST and the SA as well?

Many thanks.
RR1