countif
in [Functions]
|
Prev: Multiple Subtotals in Excel Macro
Next: entering more than seven levels of functions with in a function
From: Jim W Jim on 2 Jun 2010 19:04 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")
From: L. Howard Kittle on 2 Jun 2010 19:37 Try =SUMPRODUCT((A3:A12="week1")*(B3:B12="large")) HTH Regards, Howard "Jim W" <Jim W(a)discussions.microsoft.com> wrote in message news:98835464-5840-4C8F-ABE3-0FFABEE321A2(a)microsoft.com... >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") > >
From: Jacob Skaria on 3 Jun 2010 01:01 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") > >
From: L. Howard Kittle on 3 Jun 2010 01:19
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 W(a)discussions.microsoft.com> wrote in message news:98835464-5840-4C8F-ABE3-0FFABEE321A2(a)microsoft.com... >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") > > |