# sumif or sumifs with multiple columns

#### xryanx

##### Board Regular
 I J K L M N O 5 NEL 2 2 \$125.00 \$125.00 6 LV 2 2 \$380.00 \$380.00 7 AA 8 308 3 3

<tbody>
</tbody>

 A B C D E F G H I J K L M N O 29 1/15/2018 JY FR 308 12/8/2017 2017 Ford Escape 38 30 1/23/2018 DR FR LV 12/16/2017 2008 Ford Edge 1/25/2018 \$190.00 38 31 1/23/2018 ID FR 308 8/28/2017 2016 Hyundai Santa Fe 148 32 1/23/2018 JY FR 355 1/14/2018 2009 Chevy T&C 9

<tbody>
</tbody>

Hopefully someone can help me.

D:29 down is the location of the sale
C:29 down is the code for Full Replace (FR)or Clawback (CB)
M:29 down is the amount of the replacement
N:29 down is the amount of the clawback
I5:I12 are the locations

I am currently using the below formulas:
in M5
=SUMIF(D29:D216, I5, M29:M216) to get the Replacement totals
in N5
=SUMIF(D29:D216, I5, N29:N216) to get the Clawback totals

I would like to eliminate N:29 down and only use M:29 down for amounts.

How can I change my current formulas in M5 and N5 to read data from C29, D29, M29, I5 and add the totals to M5 (FR)and N5(CB) that I am looking for.

Also, I have another formula that I have else where on this sheet that I was trying to reference. =COUNTIFS(D29:D216, I5,C29:C216,"FR")

I hope that this made sense and any help is appreciated.

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

share file

#### xryanx

##### Board Regular
vikas9385 how do I share the file?

Replies
3
Views
438
Replies
1
Views
227
Replies
11
Views
630
Replies
2
Views
189
Replies
3
Views
270