| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
LookUp Returning more than one rows
Hi,
I have a sheet A B John 100 Alex 150 John 175 Steve 125 i want to get the sum of the entries for John, say here i have to get the result as 100+175 = 275. Is there any function for me to do it? I tried LookUp but its returning only the first value. Thanks in advance John, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup returning #n/a | Excel Discussion (Misc queries) | |||
| Lookup is not returning the right value. | Excel Worksheet Functions | |||
| Lookup returning one more than expected | Excel Worksheet Functions | |||
| Returning all values from a lookup - not just the first/last one | Excel Worksheet Functions | |||
| Returning varying rows of data through lookup function | Excel Programming | |||
Threaded Mode
