Counting Checkboxes

[Max]

Hello,

I have a report that calculates outstanding records.

I am calculating =(Count([To A/E])-(Count([From A/E]))- (
Count([Inhouse only]))). The [Inhouse only] is a check
box and I want to subtract only those records that are
checked.

I tried - Count([Inhouse only]="-1"))), but nothing.

Any ideas. Many many thanks in advance.
Max

 

[Duane Hookom]

Try:
=(Count([To A/E])-(Count([From A/E]))- ( Sum(Abs([Inhouse only]))))