Thread
:
countif
View Single Post
#
2
June 3rd, 2010, 12:37 AM posted to microsoft.public.excel.worksheet.functions
L. Howard Kittle
external usenet poster
Posts: 516
countif
Try =SUMPRODUCT((A3:A12="week1")*(B3:B12="large"))
HTH
Regards,
Howard
"Jim W" Jim
wrote in message
...
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")
L. Howard Kittle
View Public Profile
View message headers
Find all posts by L. Howard Kittle
Find all threads started by L. Howard Kittle