Prev: function to populate a cell where formula is NOT located
Next: Calculations
From: EricB on 4 Apr 2010 14:08
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

From: tompl on 4 Apr 2010 14:19
=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
>
From: Fred Smith on 4 Apr 2010 22:54
See your other post.

Regards,
Fred

"EricB" <EricB(a)discussions.microsoft.com> wrote in message
news:87548963-8B09-4105-A136-C2177934D186(a)microsoft.com...
> 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
>

 | 
Pages: 1
Prev: function to populate a cell where formula is NOT located
Next: Calculations