View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kshah_us kshah_us is offline
external usenet poster
 
Posts: 1
Default Multiple condition countif?

Hello,

How can I do some thing like this:

Count an occurance if value in col. A is "LifeMember" and value in Column E
is "Y" for a given range ? for instance A1:A100 and E1:E100 ?

I am trying COUNTIF but dont know how do I count only if BOTH conditions are
true?


--
Thanks !