Hi there i am trying to use a sum if formula to look up several ranges without success.
=SUMIF($B$7:$B$29,"APPLES",$G$7:$G$29,$H$7:$H$29,$I$7:$I$29$J$7:$J$29)
I know this formula is incorrect can someone please point me in the right direction,
Thanks in advance
Chris