Thread: countif
View Single Post
  #1  
Old June 3rd, 2010, 12:04 AM posted to microsoft.public.excel.worksheet.functions
Jim W
external usenet poster
 
Posts: 7
Default countif

I am trying to count the number of cells in column B="large" when the
condition in column A="week1". I tried the formula below and it counted all
the "week1"s along with the "large". Any Ideas?

=COUNTIF(A3:A12,"week1")+COUNTIF(B3:B12,"large")