| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To criteria with Reference from Cell
I having some datas in one column 9n many rows. i want to take reference in
some letters fot SUMPRODUCT FUNCTION EXAMPLE COL-A COL-B XA10010253 5 XXXA10012267 1 XA20045682 2 XXXA23564457 4 XAA1000253 1 XAA200000 3 I WANT FORMULA IF COL-A CONTAINS - X - SUM COL-B LIKE, IF COL-A CONTAINS - XA - SUM COL-B LIKE, IF COL-A CONTAINS - XXA - SUM COL-B WHETHER I CAN USE WITH SUMPRODUCT FUNCTION. AWAITING YOUR HELP PLEASE. THANKS PERANISH |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumifs will not work with a cell reference as criteria | Excel Discussion (Misc queries) | |||
| Reference cell in one TAB from another using two criteria | Excel Worksheet Functions | |||
| SUMPRODUCT Criteria Via Cell Reference?? | Excel Worksheet Functions | |||
| How do you reference another cell in the criteria of a SUMIF funct | Excel Worksheet Functions | |||
| Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions | |||
Threaded Mode
