Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing certain criteria - Advanced | Excel Discussion (Misc queries) | |||
PivotTable and summing/not summing | Excel Discussion (Misc queries) | |||
Advanced Conditional Formatting Ideas Needed! (ok, maybe not that advanced...) | Excel Discussion (Misc queries) | |||
Advanced use of IF | Excel Worksheet Functions | |||
Advanced DDE | Excel Programming |