sumproduct

[jessicafang]

Hi everyone,

Need help from you guys.

TO avoid having #value, I have to use sumproduct formula, can I include <"01/01/2015" within the sumproduct formula as I need to sumif the column B under the condition of before 2015 and after 2015 without creating a new column.

Many thanks,
Jess

 

[jessicafang]

Ok, this is the sumproduct I tried to use:
=SUMPRODUCT($J$3:$J$30>="01/01/2015"+0,$L$3:$L$30) the result is not correct. Thanks for helping me.

 

[Jonmo1]

Try
=SUMPRODUCT(--($J$3:$J$30>="01/01/2015"+0),$L$3:$L$30)

 

[MARZIOTULLIO]

Hi jessicafang

=SUMPRODUCT(--(B2:B6>="1/1/2014"+0),--(B2:B6<="4/23/2015"+0),--(A2:A6)) if you want write a date(is a text) in your formula

Sorry for my English