advanced summing
 

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.

advanced summing
 

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.

advanced counting
 

I'm sorry, I mis-labeled this subject. It should read,
advanced counting techniques.


-----Original Message-----
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.

.

advanced counting
 

Hi
still the link is valid :-)

--
Regards
Frank Kabel
Frankfurt, Germany

"scrabtree" schrieb im
Newsbeitrag ...
I'm sorry, I mis-labeled this subject. It should read,
advanced counting techniques.


-----Original Message-----
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.

.