Assuming your sample data is in columns A-F, try

=SUMPRODUCT(--(F3:F10000=0),--(A3:A10000="Pmt"),E3:E10000)

or

{=SUM(IF((F3:F10000=0)*(A3:A10000="Pmt"),E3:E10000 ,0))}

This second formula is an array formula. After you type it in, press
Ctrl-Shift-Enter instead of Enter. If you do it correctly, Excel will wrap
curly brackets {} around your formula (don't type them yourself.)

Hope this helps,

Hutch

"Gary" wrote:

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