Excel formula IF statement with SUMIF statement HELP

[andycreber]

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]

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))

 

[andycreber]

Hi,

That worked perfectly, thanks very much

 

[RasGhul]

You're welcome