| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif detects wrong rows
Interesting one this ..
SUMIF #1 =sumif($a:$a,"OtherBaseCost",as:as) works perfectly. SUMIF #2 =sumif($a:$a,"<<OtherBaseCost",as:as) doesn't. In Col A at which the sumif is looking, there are cells that are naturally empty and cells that contain a formula similar to: =if(a5="BaseCost",a5,"") SUMIF #2 rightly ignores the naturally empty ones but sums the row with the formula irrespective of the result! Any ideas? Best regards! Robert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Indirect in a Sumif Function returns the wrong answer | Excel Discussion (Misc queries) | |||
| What am I doing wrong with my =sumif ? | Excel Worksheet Functions | |||
| User defined function detects font colour | Excel Worksheet Functions | |||
| Simple SUMIF formula gone wrong! | Excel Worksheet Functions | |||
| sumif wrong result | Excel Worksheet Functions | |||
Threaded Mode
