counting only second scenario

[renjithpl]

I have two fields A and B,

I want to say if A and B are null, then say 'no', and then if B is filled with data and if A is blank then, say 'yes'

And finally I want the count of only 'yes'

i used the below formula

=If(IsNull(A & B), 'no', Count(If(IsNull(A), 'yes')))

fyi... the first condition is must i cant ommit (If(IsNull(A & B), 'no')

But its showing the data of both no and yes.

can any one help me..

[Anonymous]

Could also do something like the following.

sum( If ( IsNull(A) and IsNull(B), 0, if ( IsNull(A),1) ) )

rgrds

Anita

[renjithpl]

hey cool dude... it works..thanks a lot

[SunilChauhan]

hi,

hope this will work

If(IsNull(a & b), 'no',Count(If(IsNull(a), -1,'yes')))

gud luck