Multiple Condition IF Statement in ARRAY formula EXCEL July 15, 2023 samnangblogger WORKS: =SUM(IF($I$2:$I$9999<>"",$U$2:$U$9999)) =SUM(IF(YEAR($I$2:$I$9999)=YEAR(AD2),$U$2:$U$9999)) =SUM($M$2:$M$9999="",$U$2:$U$9999)) ***Ctrl+Shift+Enter is used to enter the formula. Email ThisBlogThis!Share to XShare to Facebook