Hi
see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards
Frank Kabel
Frankfurt, Germany

"scrabtree" schrieb im
Newsbeitrag ...
I have a range of cells in Sheet1 A1:Z100. In Sheet2, in
Cells A1, B1, C1, and D1 there will be four values (the
first three values will be listed several times in Sheet1
Columns A,B, and C respectively).

I need a code that will look down Sheet1 Column A, Column
B and Column C and find the rows where only the adjacent
cells in Columns A, B, and C match the values in Sheet2
A1, B1 and C1 (only in a few rows will the adjacent cells
in Columns A, B and C match the values in Sheet2, A1, B1
and C1 exactly).

I then need it to look out these rows and count the cells
between Columns C:F that match the value in Sheet2 Cell
D1. I need this answer to be lodged in Sheet3 Cell A1.

Please help...and thanks in advance.