| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
from sumproduct to a lookup please
Steved
Hello from Steved Below will do a sum off 1-City how do I change it to do a lookup please. SUMPRODUCT(--(Data!$A$2:$B$2001="1-City")) Thankyou. |
|
#2
|
|||
|
|||
|
Please ignore as I've now re done the question.
Thankyou. -----Original Message----- Steved Hello from Steved Below will do a sum off 1-City how do I change it to do a lookup please. SUMPRODUCT(--(Data!$A$2:$B$2001="1-City")) Thankyou. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Function Problem | Excel Discussion (Misc queries) | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Linear Mode
