sumif or sumifs with multiple columns

xryanx

Board Regular
Joined
Jul 30, 2015
Messages
59
IJKLMNO
5NEL 22 $125.00$125.00
6LV2 2$380.00 $380.00
7AA
83083 3

<tbody>
</tbody>

ABCDEFGHIJKLMNO
291/15/2018JYFR30812/8/2017 2017 Ford Escape 38
301/23/2018DRFRLV12/16/2017 2008 Ford Edge1/25/2018$190.00 38
311/23/2018IDFR3088/28/2017 2016 Hyundai Santa Fe 148
321/23/2018JYFR3551/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.
 

Some videos you may like

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.

Watch MrExcel Video

Forum statistics

Threads
1,109,072
Messages
5,526,628
Members
409,713
Latest member
roman9980

This Week's Hot Topics

Top