Sum in a report

[Fipp]

I am trying to find the sum of the number field [yards]
where [passzone]=1 and [compinc]="1"

This is in a footer section of a report called "passzone"
The report is based off a query called "allpassplays"

I also want to know the number of times where
[passzone]=1
[passzone]=1 And [compinc]=1

for those I have the following and they appear to be
working correctly.

=Abs(Sum([passzone]=1))
=Abs(Sum([passzone]=1 And [compinc]="1"))

Thanks for the help!

 

[Duane Hookom]

Try:
=Abs(Sum( ([passzone]=1 And [compinc]="1") * [Yards]))