Thanks for the response guys, but I'm not sure that either one does the job
I'm looking to do.
Basically, I need to use the SUMIF function with two criteria. Here is an
example of my current SUMIF functions:
=SUMIF('Data Record'!C:C,"Name",'Data Record'!I:I)
Which means that for every row in column C that contains "NAME" add in the
corresponding cell from column I.
What I need to do is expand that by one criteria.
I need the formula to say: For every row that contains "NAME" in column C
and contains "0" in column J, add 1.
Basically, I need a count function based on two criteria.
1) column contains a specific name AND
2) column J contains the number "0"
Hopefully this helps?
"Max" wrote:
Something along these lines should suffice:
In C1: =SUMPRODUCT((A1:A20="Name1")*(B1:B20=0))
Use the smallest range sufficient
to cover the max expected extent of data in cols A and B
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dsk3808" wrote:
I need to count the number of times a person, who's name is in column A, has
a specific value,"0", in column B, where the worksheet contains an
ever-increasing amount of records (rows). Is there an easy way to make this
happen? Any help is appreciated. Thanks