=SUM(IF(('FUTURE DAYS'!$H$2:$H$3000="Central Illinois 60")*('FUTURE DAYS'!$C$2:$C$3000="Connect")*('FUTURE DAYS'!$H$2:$H$3000=TODAY()),'FUTURE DAYS'!$E$2:$E$3000))

What I am trying to do is sum column "E" if it meets all the conditions listed above. I have tried this as an array also. This formula keeps returning zero and the answer should be 48. Any help would be appreciated. Thanks!!!