| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help with a lookup and count and if statemnt
Hi,
I have 2 rows and 12 columns. The first rows is the headers second is the values. Ld1 Ld2 Ld3 Ld4 Ld5 Ld6 Ld7 Ld8 Ld9 Ld10 .... 2 10 0 0 0 98 0 0 10 15 ...... it looks sumthing like this. I want a formula to go through the row and tell me which colmns in row 2 have a number greater than 0 in this format : Ld1 + Ld2 + Ld6 + Ld9 + Ld10 Any suggestions?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup and count | Excel Discussion (Misc queries) | |||
| lookup count | Excel Discussion (Misc queries) | |||
| count and lookup | Excel Worksheet Functions | |||
| count in a lookup ? | Excel Discussion (Misc queries) | |||
| I'm using an if statemnt and the result if true points to one cell | Excel Discussion (Misc queries) | |||
Threaded Mode
