counting based on two criteria

  • Thread starter Thread starter Nate
  • Start date Start date
N

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.
 
=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)
 
-----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.
.
Click to expand...
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
 
Back
Top