Sum based on a condition

[Jill]

I need to develop a report that sums commissions by office based on account number.

I've created a field that assigns a "DeptIDMarker" of either "A" or "B". Now what I can't figure out is how to Sum(Commission) where DeptIDMarker = A and then another field to Sum(Commission)where DeptIDMarker = B.

I hope someone can understand and help. I would really appreciate any suggestions.

Thank you.

 

[Richie]

=Sum(IIf([DeptIDMarker]="A",[Commission],0))

 

[Jill]

Thanks, Richie. That worked great!!