Thread: CountIf
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Question Boy Question Boy is offline
external usenet poster
 
Posts: 25
Default CountIf

I'm hoping someone can give me a little guidance.

I a spreadsheet with several columns, 2 of which are of interest (B and E)

I need to count the number of time there are 'B' in column E for which
column B's value = 'Open' and this base on the total number of values in the
table (variable region).

I started using =COUNTIF(Donnees!E2:E90,"B") but can't seem to get it to
work with the double criteria it must = B and the value in column B = "Open"

Thank you

QB