Only use the SUMPRODUCT

[marreco]

Hi
how to calculate a date based on numbers and only using the SUMPRODUCT?
I need to sum ​​the values ​​equal or higher to date (05/06/2013) DD / mm / yyy

Date Value
03/06/2013 304,77
03/06/2013 304,77
03/06/2013 63,51
03/06/2013 790,09
03/06/2013 -127,42
03/06/2013 Verificar
03/06/2013 157,14
03/06/2013 -17,28
03/06/2013 Verificar
03/06/2013 366,67
03/06/2013 -40,33
03/06/2013 0
03/06/2013 219,58
03/06/2013 Verificar
03/06/2013 1003
03/06/2013 5003
03/06/2013 1000
04/06/2013 -402,77
04/06/2013 -464,2
04/06/2013 -375,2
05/06/2013 -484,44
05/06/2013 203
05/06/2013 Prejudicado
05/06/2013 350
05/06/2013 350
05/06/2013 -88,45

(I need to use the SUMPRODUCT and NOT SUMIF or SUMIFS)

[benishiryo]

hi marreco, try:
=SUMPRODUCT(--(A2:A30>=--"5jun2013"),B2:B30)

[Tony Valko]

Try this...

Dates in column A, values to sum in column B.

D2 = 05/06/2013

Then:

=SUMPRODUCT(--(A2:A10>=D2),B2:B10)

[marreco]

Hi

Thank you very much!!!

[jhren]

.....deleted

[Tony Valko]

You're welcome!