| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
It has worked indeed. Thank you so much, Domenic!
"Domenic" wrote: Try... =SUMPRODUCT(--(ISNUMBER(MATCH(A1:G7,{"AAB","BMN"},0))),B1:H7) OR =SUMPRODUCT(--(ISNUMBER(MATCH(A1:G7,J1:J2,0))),B1:H7) ....where J1:J2 contains your letters, such as AAB and BMN. In your example, both these formulas would return 296. Hope this helps! In article , "Peter FS" wrote: I appreciate the reply by you and others. It may well be because I did not make myself clear so none of the formulae worked. Why don't I copy a portion of the sheet and show you folks how it looks like AAB 4 BMN 12 AAB 8 AAB 11 AAB 5 BMN 32 BMN 6 UWO 23 BMN 67 VBN 4 UWO 45 BMN 4 BMN 34 AAB 5 AAB 3 AAB 7 BMN 2 BMN 7 AAB 2 BMN 2 BMN 3 AAB 9 AAB 1 BMN 3 UWO 7 AAB 2 UWO 8 BMN 67 The idea is that I can run a function to look up all those same combinations and provide the sum of the corresponding values in the adjacent cells. Thanks in advance again! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to search in excel with condition | Excel Discussion (Misc queries) | |||
| Search and Display Sheet Name | Excel Discussion (Misc queries) | |||
| search in a sheet and selection? | Excel Discussion (Misc queries) | |||
| Search should highlight entire row in Excell in red | Excel Discussion (Misc queries) | |||
| Search for a Sheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
