countif
In case you are using xL2007 check out the function..
=COUNTIFS( Criteriarange1,Criteria1,Criteriarange2,Criteria2, ...)
--
Jacob (MVP - Excel)
"Jim W" wrote:
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")
|