Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using SUMPRODUCT with a VLOOKUP
Hi
I have a spreadsheet that goes as follows. Column A is Salesperson's name and Column B is Achevied Sales Target (Yes or No). Column A gets it data from anothr spreadsheet using a VLOOKUP table, hence each value is preceded with a ' sign. C I am using SUMPRODUCT to count the number of times a salesperson in A has hit the target in B. The formula is as follows: =SUMPRODUCT((I2:I22="YES")*(J2:J22="JOE")) This only works if I retype "JOE" in the cell as text, deleting the v-lookup formula. Obviously this is tedious and defeats the purpose of the vlookup. Is there a way to correct my formula OR use a new formula? Thanks! Steph |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct and vlookup | Excel Worksheet Functions | |||
VLookup VS SumProduct | Excel Discussion (Misc queries) | |||
SUMPRODUCT or VLOOKUP | Excel Worksheet Functions | |||
do i use vlookup or sumproduct??? | Excel Discussion (Misc queries) | |||
Sumproduct and Vlookup | Excel Discussion (Misc queries) |