If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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") |
#2
|
|||
|
|||
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") |
#3
|
|||
|
|||
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") |
#4
|
|||
|
|||
countif
Hi Jacob,
You know... That COUNTIFS in 2007 seems a lot more intuitive than the SUMPRODUCT of 2003. If you check out HELP for SUMPRODUCT in 2003 it does not even get you near to the solution I offered for the question posed. Only exposure to this group did I know this would work, but I can see I might more readily grasp the 2007 'splaning of COUNTIFS in 2007. (I think...bg) Not ready to upgrade yet, probably wait until 2010 makes a bigger splash. 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") |
Thread Tools | |
Display Modes | |
|
|