0

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

1 Answer 1

1

Try using the date function and there's no need to reference the sheet there!

=SUMIF('Data Form'!G:G,DATE(2010,1,1),'Data Form'!N:N)

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .