| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF returns no value
My SUMIF argument returns no value but when checking fx the Sum_range
reflects the correct value, but Formula result is R €“ =SUMIF($A4,'TB SAICMB'!$A$4:$A$500,'TB SAICMB'!S4) Any help will be appreciated EricB |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF returns no value
=SUMIF('TB SAICMB'!$A$4:$A$500,$A4,'TB SAICMB'!$S$4:$S$500)
"EricB" wrote: My SUMIF argument returns no value but when checking fx the Sum_range reflects the correct value, but Formula result is R €“ =SUMIF($A4,'TB SAICMB'!$A$4:$A$500,'TB SAICMB'!S4) Any help will be appreciated EricB |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF returns no value
See your other post.
Regards, Fred "EricB" wrote in message ... My SUMIF argument returns no value but when checking fx the Sum_range reflects the correct value, but Formula result is R €“ =SUMIF($A4,'TB SAICMB'!$A$4:$A$500,'TB SAICMB'!S4) Any help will be appreciated EricB |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF & INDIRECT Returns #Value! | Excel Worksheet Functions | |||
| Is there something like a SUMIF that just returns the info. in a c | Excel Worksheet Functions | |||
| sumif returns #VALUE! when linked workbook is closed | Excel Worksheet Functions | |||
| sumif formula returns incorrect value | Excel Worksheet Functions | |||
| Sumif range returns #NUM! | Excel Worksheet Functions | |||
Hybrid Mode
