Sumif and Today
 

Why is this not working, range F3:IV3 has dates and F5:IF5 values?

+SUMIF($F$3:$IV$3,"<TODAY()",F5:IV5)

Thank you

Sumif and Today
 

Hi Esrei,

Try:

=SUMPRODUCT(($F$3:$IV3<TODAY)*(F5:IV5))

(not tested)

HTH
--
AP

"Esrei" a écrit dans le message de news:
...
Why is this not working, range F3:IV3 has dates and F5:IF5 values?

+SUMIF($F$3:$IV$3,"<TODAY()",F5:IV5)

Thank you

Sumif and Today
 

or

=SUMIF($F$3:$IV$3,""&TODAY(),F5:IV5)


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=553280