Not sure if I am on the correct forum, I am trying to use sumifs to calculate
totals for data on different rows

Type Units DOS Charges Paid Balance

Chg 11.00 06/06/2008 880.00 0.00 0.00
Pmt 06/06/2008 0.00 0.00 0.00
Pmt 06/06/2008 0.00 0.00 0.00
Adj 06/06/2008 0.00 0.00 0.00
Pmt 06/06/2008 0.00 560.00 0.00
Chg 18.00 06/10/2008 1,440.00 0.00 711.00
Pmt 06/10/2008 0.00 729.00 0.00
Chg 16.00 06/11/2008 1,280.00 0.00 1,280.00
Pmt 06/11/2008 0.00 0.00 0.00
Pmt 06/11/2008 0.00 0.00 0.00
Chg 13.00 06/11/2008 1,040.00 0.00 485.00
Pmt 06/11/2008 0.00 0.00 0.00
Adj 06/11/2008 0.00 0.00 0.00
Pmt 06/11/2008 0.00 100.00 0.00

This is a small sample of a report that I am trying to analysis, I am trying
to get a total of all BCBS Payments on accounts that have a 0.00 balance.
This report is about 10,000 lines in excel, too long to manually delete
accounts with a balance

If Chg Balance = 0.00 then total Pmt Paid

Thanks

Gary