In a report I have a two fields 1. Status and 2. Est. Count.. I do =sum([ak]) to get the total number for Est. Count.

How can I have it check the status, and if it equals completed I want to total up and display the completed records total and then subtract them from the sum([ak]) to give me what the difference is.