Thank you for your replies but you credit me with too much knowledge.
I understand the €œrange€� and €œcriteria€� but what does the -- stand for?
I have a table similar to below.

A:A B:B C:C
102 Y 1
103 Y 1
116 Y N
117 Y N
102 N N
103 N 1
116 Y N
117 Y N

I need two formulas which I understand will be very similar.
The first one is where I want to find how many times 102 appears in A:A and
where the 102 also has a Y in that row in B:B. The second formula is the same
but has the addition that C:C also has a 1 in the same row.

When I use COUNTIFS the first formula is
=COUNTIFS(April!A:A,B4,April!B:B,"y") the B4 equals the
102 value.

Thanks in advance

Larry


"daddylonglegs" wrote:

I imagine Teethless mama has answered your question, if not the please post
the COUNTIFS formula you're using

"Teethless mama" wrote:

=SUMPRODUCT(--(rng1="criteria1"),--(rng2="criteria2"),--(rng3="criteria3"))

"Larry Byrne" wrote:

At home I have Excel 2007 but at work we use Excel 2003.
Excel 2007 now has a new function called COUNTIFS. (Counts the number of
cells within a range that meet multiple criteria)
Obviously when I send the file back to work it no longer works properly.
Is there a way to reproduce the function in Excel 2003?