Search code examples
excelexcel-formula

Excel issue with sumif formula

i want to add two cells together if a separate cell is greater than another cell, what formula should i use on excel, thanks. trying to use =SUMIF(E1+E6,E2">"E8) with no success atm.

keeps saying it doesnt work, please please help

Solution

  • I think it's really more of a "you" issue not an Excel one. Perhaps you should try another approach?

    =IF(E2 > E8, E1 + E6, 0)

=IF(E2 > E8, E1 + E6, "")