| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i use sumproduct if my lookup table is alpha or alpha num?
Can I use sumproduct formula if my table is as follows ? Yr End Rating Mid Yr Rating A B C D A same 1 down 2 down 3 down B 1 up same 1 down 2 down C 2 up 1 up same 1 down D 3 up 2up 1 up same |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do i use sumproduct if my lookup table is alpha or alpha num?
No, but you can if the cells contain numbers like -2, 0, or +2, where the
cell might use a custom format such as 0 "up";0 "down";"same" to show display values like you show in your example. -- David Biddulph "Angie" wrote in message ... Can I use sumproduct formula if my table is as follows ? Yr End Rating Mid Yr Rating A B C D A same 1 down 2 down 3 down B 1 up same 1 down 2 down C 2 up 1 up same 1 down D 3 up 2up 1 up same |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort alpha neumeric fields that have an alpha suffix? | Excel Worksheet Functions | |||
| Mixing text and alpha in sumproduct arrays | Excel Worksheet Functions | |||
| Lookup the last alpha numeric value | Excel Discussion (Misc queries) | |||
| Lookup the last alpha numeric value in a column | Excel Discussion (Misc queries) | |||
| The colums changed from alpha to numeric how do you make it alpha | Excel Discussion (Misc queries) | |||
Linear Mode
