Mark,

You need to specify in which column you are looking for the value in cell 'Mnths Tracking'!C3 (I'm
assuming G), but you could use something like this:

=SUMPRODUCT(('MTD Orders'!$G1:$G9993='Mnths Tracking'!C3)*('MTD
Orders'!$B1:$B9993=DATEVALUE("1/1/08"))*('MTD Orders'!$B1:$B9993<=DATEVALUE("7/1/08"))*'MTD
Orders'!$L1:$L9993)


HTH,
Bernie
MS Excel MVP


"Mark Allen" wrote in message
...
Is it possible to use multiple critera for a sum if statement ?

This is what I have so far:
=SUMIF('MTD Orders'!$G:$M,'Mnths Tracking'!C3,'MTD Orders'!$L1:$L9993)

I also want to specifiy a date range from column B ie. from 1/1/08 to 7/1/08.

Can anyone help please ?

Regards