Thread: Multiple critera with in a sumif statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mark Allen Mark Allen is offline
external usenet poster
  
Posts: 54
Default Multiple critera with in a sumif statement
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
Reply With QuoteReply With Quote