Hello
I managed to create a vlookup table on the source sheet and another where
data is chosen on the users sheet but to advance is too technical.
I need to display certain data chosen from the dropdown list to display in
another column on the users sheet. Party1 and Party3 to display in column G.
Item Party1 and Party3 (in column A) in the vlup have a code Y (column C) in
the vlup source. Only need about 15rows to display Y and N item results
listed in the users sheet.
ie. Party 1 & 3 need to be displayed, summed and counted on the users sheet
as they are both coded as Y.
A | B | C | ... | G
1. Party1 | $80 | another Vlup table used elsewhere |
2. Party1 | $80 | another Vlup table used elsewhere |
3. Party5 | $90 | another Vlup table used elsewhere |
4. Party3 | $60 | another Vlup table used elsewhere | Dsiplay column starts
here
So the results in G starting at row 4:
(Y code) Party1 x2 (hits) =$160
(Y code) Party3 x1 =$60
(N code) Party5 x1 =$90
I searched in Excel and thought about CountIf for hits would be perfect BUT,
how to sum those hits?
Now the hardest part, I need the HITS and $value to be used in other
formulas like how many times did they speak to someone different to find the
hit rate of the item sold and how many were sold against each person.
Contacts is H3 where number is manually entered.
ie. Contacts/hits = $ (for Y code)
ie. Contacts/hits = $ (for N code)
Too complicated! Help.
|
Similar Threads
