Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use VLOOKUP in a sumproduct calculation
Hi,
Is it possible to use VLOOKUP in a SUMPRODUCT calculation? I have a large series of data and I want to count the number of instances where a row has several criteria - and I can nearly cover it in a single SUMPRODUCT formula. An example of the data I am counting is: Priority Included Achieved A Yes Q2 2007 A Yes Q1 2008 A No Q1 2008 B Yes Q1 2008 A Yes Q2 2008 and I am looking to count the number of priority A's that have a "Yes" in the column Included and were achieved in Q2 2008 or before. So in this example the count would be 3. The problem I have is that one of my criteria is that a milestone achieved was in the quarter I am looking at or before. The data in this column is in the form "Q[NUMBER] [YEAR]" (see example above). The way I am planning to do is to have a lookup table elsewhere which converts each quarter into a ranked number e.g.: Quarter Rank Q1 2008 1 Q2 2008 2 Q3 2008 3 Any ideas how to get the VLOOKUP to work in the SUMPRODUCT function - please help me!!! Sorry if its not that clear but let me know what clarification you need Thanks in advance Ed |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct calculation for January 09 | Excel Worksheet Functions | |||
Calculation using VLookup | Excel Worksheet Functions | |||
Advance Sumproduct calculation | Excel Worksheet Functions | |||
Sumproduct calculation between two workbooks | Excel Worksheet Functions | |||
returns calculation using sumproduct | Excel Worksheet Functions |