Multiple Criteria with Countif Statements

=sumproduct(--(c1:c1000="monster.com"),--(d1:d1000="profile))

is one way.

Sumproduct likes to see numbers. The double minus signs change trues/falses to
1's and 0's.

Gaeton Biscardi wrote:
>
> My question to use, is how do I use a similar formula when dealing
> with text in all cells? For instance, how can I write a countif
> statement that will return all the "Profile" in column D that also
> have "Monster.com" in column C?
>
>
> A B C D
>
> Last Name First Name Source Status
> Patel Mainakini Monster.com Profile
> Seres Amy CollegeCentral.com Interview

--

Dave Peterson
ec35720@msn.com

Hello,

or this way:
=sumproduct((C1:C1000="monster.com")*(D11000="profile"))

Regards
Beate


Dave Peterson wrote in message news:<4148E68D.53FD5614@msn.com>...
> =sumproduct(--(c1:c1000="monster.com"),--(d1:d1000="profile))
>
> is one way.
>
> Sumproduct likes to see numbers. The double minus signs change trues/falses to
> 1's and 0's.
>
> Gaeton Biscardi wrote:
> >
> > My question to use, is how do I use a similar formula when dealing
> > with text in all cells? For instance, how can I write a countif
> > statement that will return all the "Profile" in column D that also
> > have "Monster.com" in column C?
> >
> >
> > A B C D
> >
> > Last Name First Name Source Status
> > Patel Mainakini Monster.com Profile
> > Seres Amy CollegeCentral.com Interview