counting based on two criteria

[Nate]

I am trying to count using two criteria. If data in A1
is what I want then I want to look at b1, if that data is
what I am looking for, then I want it to be counted. So
for the final result I just want the number of items in
my database that meet the given criteria.

 

[Frank Kabel]

Hi
try something like
SUMPRODUCT(--(A1:A1000="cond_1"),--(B1:B1000="cond_2"))

 

[Bob Phillips]

=SUMPRODUCT((A1:A100-criteria1)*(B:B100=criteria2))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Viksit]

-----Original Message-----
I am trying to count using two criteria. If data in A1
is what I want then I want to look at b1, if that data is
what I am looking for, then I want it to be counted. So
for the final result I just want the number of items in
my database that meet the given criteria.
.

Hi

USe the function SUMPRODUCT

=SUMPRODUCT((A1:A10="Val_1")*(B1:B10="Val2"))

See more details at
http://www.microsoft.com/office/previous/xp/columns/column1
0.asp

Cheers,

Viksit