Combine Statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone help me to combine these statements below?


=Sum(IIf([Status]="Win" And [Region]="Mid-Atlantic",1,0)) BTW this is text
box89
AND
=[Text89]/[Overall Count of All]

I can't figure out how to make these work in one. Thanks!
 
To foolow you two fields then it should be

=Sum(IIf([Status]="Win" And [Region]="Mid-Atlantic",1,0))/[Overall Count of
All]
 
Back
Top