Countif help needed
in [Functions]
|
From: Jessica Krall on 11 May 2010 11:12 Thank you so much...enjoy your day! Jess -- -------- Jessica Krall Virginia USA "T. Valko" wrote: > Try something like this... > > =SUMPRODUCT(--(A1:A10="car"),--(N1:N10>499)) > > Note that with SUMPRODUCT you *can't* use entire columns as range references > unless you're using Excel 2007. > > -- > Biff > Microsoft Excel MVP > > > "Jessica Krall" <Jessica Krall(a)discussions.microsoft.com> wrote in message > news:1C4594ED-8F33-4E1E-9FB8-80066C050443(a)microsoft.com... > >I am trying to use a countif statement for column A to count the number of > > times a District is "CAR" PLUS those CAR listings where column N (DAYS) is > >>499. I've tried =COUNTIF(A:A="CAR")+(N:N=">499") and > > =SUM((District="CAR")*(Days>499)) as an array, but neither works...help > > please!! > > > > Jess > > > . >
From: T. Valko on 11 May 2010 13:47
You're welcome! -- Biff Microsoft Excel MVP "Jessica Krall" <JessicaKrall(a)discussions.microsoft.com> wrote in message news:480104C5-6A6F-4132-A69A-61607BB2AB35(a)microsoft.com... > Thank you so much...enjoy your day! > Jess > -- > -------- > Jessica Krall > Virginia USA > > > "T. Valko" wrote: > >> Try something like this... >> >> =SUMPRODUCT(--(A1:A10="car"),--(N1:N10>499)) >> >> Note that with SUMPRODUCT you *can't* use entire columns as range >> references >> unless you're using Excel 2007. >> >> -- >> Biff >> Microsoft Excel MVP >> >> >> "Jessica Krall" <Jessica Krall(a)discussions.microsoft.com> wrote in >> message >> news:1C4594ED-8F33-4E1E-9FB8-80066C050443(a)microsoft.com... >> >I am trying to use a countif statement for column A to count the number >> >of >> > times a District is "CAR" PLUS those CAR listings where column N (DAYS) >> > is >> >>499. I've tried =COUNTIF(A:A="CAR")+(N:N=">499") and >> > =SUM((District="CAR")*(Days>499)) as an array, but neither works...help >> > please!! >> > >> > Jess >> >> >> . >> |