Formula Problems...

[sstorm]

Here is my formula...

=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!!!

 

[sstorm]

Yes...the sheet is called exactly Future Days. Column E is a list of numbers for how many connects are going to be done on that particular date.

column c column d col e column h
CONNECT 01/08/04 1.00 Central Illinois 60
CONNECT 01/09/04 1.00 Central Illinois 60
CONNECT 01/08/04 2.00 Central Illinois 60
CONNECT 01/12/04 1.00 Central Illinois 60
CONNECT 01/16/04 1.00 Indiana 65
CONNECT 01/09/04 1.00 Central Illinois 60
CONNECT 01/08/04 2.00 Central Illinois 60
CONNECT 01/08/04 1.00 Central Illinois 60

Sorry...I don't know how to put it into a table like in a previous post.

 

[just_jon]

=SUMPRODUCT(--('FUTURE DAYS'!H2:H3000="Central Illinois 60"),--('FUTURE DAYS'!C2:C3000="Connect"),--('FUTURE DAYS'!D2:D3000=AB2),'FUTURE DAYS'!E2:E3000)

This does not work, it provides me with an N/A.

Does N/A exist in the range E2:E3000?

 

[sstorm]

I found a formula that worked...

=SUMIF('FUTURE DAYS'!$I$2:$I$2540,CONCATENATE($H$18," CONNECT ",TEXT($AB$2,"mm/dd/yy")),'FUTURE DAYS'!$E$2:$E$2540)


Thanks for all your help everyone!!!

Stacy

 

[Aladin Akyurek]

I found a formula that worked...

=SUMIF('FUTURE DAYS'!$I$2:$I$2540,CONCATENATE($H$18," CONNECT ",TEXT($AB$2,"mm/dd/yy")),'FUTURE DAYS'!$E$2:$E$2540)


Thanks for all your help everyone!!!

Stacy

Does this mean that your date column consist of text-dates, not of real dates?