I want to SUMIF
in another worksheet values having a specific date as criteria.
Like :
=SUMIF('Data Form'!G:G,"'Data Form'!1/1/2010",'Data Form'!N:N)
I want a specific value in a cell (i.e 1/1/2010) as the criteria in stead of the cell (i.e G8) being the criteria.
I don't want this:
=SUMIF('Data Form'!G:G,'Data Form'!G6,'Data Form'!N:N)
thanks, Oury