IF statement to show value depending on two SUMIF results

[XL User]

Hi guys,

I'm trying to do an IF statement to show "Apples" if a certain sumif based on a range is greater than another sumif based on a different range e.g. Oranges. And then it should show "Oranges" if the total value for the cells that correspond to "Apples" is not greater. Here's what I have so far:

=IF(SUMIF(Dataset!C11:C66,"Apples",Dataset!E11:E66)>(SUMIF(Dataset!C11:C66,"Oranges",Dataset!E11:E66), "Apples", "Oranges")

Can't seem to figure out what's wrong or lacking. Please help


Regards,
XL User

 

[XL User]

Hi all, please disregard. All good now


Cheers!