View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
brentm brentm is offline
external usenet poster
 
Posts: 35
Default SUMIF with multiple criteria

Ok, here's one for the advanced users.

I have a sheet that is being totalled by month with the following catagories:
I have to sum a column if multiple criteria are met. First, I need to take
into account the status (awarded, submitted, lost, etc.), then the sum must
look to see if those amounts are within a certain month. any ideas on using
multiple criteria within a sumif statement?

Brent M