| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum if match any six numbers
Hi,
I need an array function such that: Sum(If( G2:G5836 = <any six numeric digits, I2:I5836,0)) Obviously, I need the part on how to match any six numeric digits (e.g. 123456) in the above formula, can someone please help me out on this? Thanks much in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to match between same numbers | Excel Discussion (Misc queries) | |||
| how can I match numbers from two columns? | Excel Worksheet Functions | |||
| how can I match numbers from two columns? | Excel Worksheet Functions | |||
| How can I match numbers from two columns? | Excel Discussion (Misc queries) | |||
| How to find MATCH numbers ? | Excel Worksheet Functions | |||
Threaded Mode
