Named Ranges With Dates

[ExcelRoy]

Hi Guys,

I have the following formula

=IF(Name_Player_004="","-", SUMPRODUCT((B318:B387>Date_P1_From)*(B318:B387< Date_P1_To)*(D318:D387)))

Date_1_From is 13/08/11
Date_1_To is 05/09/11

Column B has the dates and column D has the figures

I need this formula to calculate including the 2 dates?
At the moment the formula doesn't calculate on these dates

Thanks in advance

 

[ExcelRoy]

edit

 

[T. Valko]

Hi Guys,

I have the following formula



"=IF(Name_004="","-", SUMPRODUCT((B318:B387>Date_1_From)*(B318:B387<?XML:NAMESPACE PREFIX = Date_1_To)*(D318 /><Date_1_To)*(D318:D387)))"< p>

Date_1_From is 13/08/11
Date_1_To is 05/09/11

Column B has the dates and column D has the figures

I need this formula to calculate including the 2 dates?
At the moment the formula doesn't calculate on these dates

Thanks in advance

Looks like part of your formula is missing.

If the formula contains the "less than" character put space characters on both sides of it. The forum software interprets the "less than" character as a html code character.
</Date_1_To)*(D318:D387)))"<>

 

[ExcelRoy]

Yeah, i just figured that out as you replied, should be all the formula now

thanks

 

[ExcelRoy]

I have played around a bit and used the >= and <= and it appears to work

But is this a reliable way to achieve my goals?

Thanks

 

[T. Valko]

I have played around a bit and used the >= and <= and it appears to work

But is this a reliable way to achieve my goals?

Thanks

Yes, that's a valid and reliable method.

If you're using Excel 2007 or later and don't need backwards version compatibility I recommend using the SUMIFS function. It's bit more efficient than the SUMPRODUCT function.