| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMIF HELP
I've used the below formula and it works. However, I need to us it again but
I won't have ALL of the information that is in quotes. The only thing that will be for certain is the 20070.53661.FMS. However, what precedes the information will be various numbers but the periods(.) will always be the same place. Can someone help me with a SUMIF formula for this? =SUMIF('07-08 Object Code Breakdown'!E4:E1000,"53000.5300200010.00300.206004 .20070.53661.FMS",'07-08 Object Code Breakdown'!B4:B1000) -- Thank you for your help MO Albany, NY |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
| SUMIF and AND help | 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
