Excel formula IF statement with SUMIF statement HELP

andycreber

Board Regular
Joined
May 20, 2010
Messages
61
Hi there, I am trying to write a formula that is a IF statement with 2 different SUMIF criteria based on the true of false result but the false default is overriding the true.

[FONT=Arial, Helvetica, sans-serif]my formula that I am using but it does not wotk the way I want it too:

[/FONT]=IF(A63=B63,SUMIF('Smarty Download'!C:C,'Donations - Full Listing'!A63,'Smarty Download'!P:P),SUMIF('Smarty Download'!C:C,'Donations - Full Listing'!B63,'Smarty Download'!P:P))

in cell A63 I have text = abc company

in cell b63 i have text = xyz company

column C i have text various text that could be abc company or xyz company

I want to sum if a63 = b63 then add up the values in column P for that name in a63 or add up the value in column P if the name in b63 is found in column C

But i don't want dupplicate figures if the names both match.

Is there another way to write this formula?

thanks in advance
 

RasGhul

Well-known Member
Joined
Jul 15, 2016
Messages
606
Hi Andy,

Just to clarify your goal;

If the Company in A63 appears in column C, A63 wins & sumif column $p:$p against A63, If FALSE sumif against B63?

=IF(COUNTIFS('Smarty Download'!C:C,'Donations - Full Listing'!A63)>0,SUMIFS('Smarty Download'!P:P,'Smarty Download'!C:C,'Donations - Full Listing'!A63),SUMIFS('Smarty Download'!P:P,'Smarty Download'!C:C,'Donations - Full Listing'!B63))
 

Forum statistics

Threads
1,077,633
Messages
5,335,371
Members
399,014
Latest member
hamzalaarif

Some videos you may like

This Week's Hot Topics

Top