| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif or something
Hello,
Got two sheet with the following data: Sheet1 Sheet2 A B A 0010711463 29 0010711463 sumif( 0010701463 15 0010711463 10 0000711463 45 I need a function that looks to the first three digits, second third digits and last four digits, sum if the three sets of digits are equals, if not bring back an error. Please find me logic to this madness€¦ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif? | Excel Discussion (Misc queries) | |||
| Help with SUMIF | Excel Discussion (Misc queries) | |||
| Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
| nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Threaded Mode
