subtotal with condition

[Katja.Buckley]

I have a report that has properties for Sale and for Lease. I have all
for lease listed first, and all the sale listed after, each with
building sqft.
I have a subtotal for each broker giving me a combined total for sale
and lease.
I would like to have a subtotal for all their sqft for lease and a
subtotal for sale.

I used: =Sum([Building Sqft]="Sale")

and it won't work :-((

any help would be appreciated!

 

[Katja.Buckley]

disregard, I figured the problem out. I didn't have a footer! Duh!!!!