Sum if meeting all conditions...

sstorm said:

Please help...I want to sum if there are three conditions in a seperate workbook.

In column "C" I want it to pull "CONNECT"
In column "D" I want it to pull the date in column "A"
In column "H" I want it to pull "Central Illinois 60"

if meeting all this criteria, I want it to sum column "E". I am going to put this sum into a new worksheet on a different file. Is this possible??? Thanks in advance!!

Stacy

Click to expand...

sstorm said:

This is my formula...it returns #NA. It should return 40.

=SUMPRODUCT(('[Future Days Template.xls]FUTURE DAYS'!$C$2:$C$3000="CONNECT")*('[Future Days Template.xls]FUTURE DAYS'!$D$2:$D$3000=A1)*('[Future Days Template.xls]FUTURE DAYS'!$H$2:$H$3000="Central Illinois 60")*'[Future Days Template.xls]FUTURE DAYS'!$E$2:$E$3000))

Stacy

Click to expand...