subtotal with condition

  • Thread starter Thread starter Katja.Buckley
  • Start date Start date
K

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!
 
Back
Top