View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Denise_NOLA Denise_NOLA is offline
external usenet poster
 
Posts: 3
Default SUMIF or HLookup

Does Excel recognize months in their chronological order? For example I have
the following data:

Jan Feb Mar
Reg 1 5 9 11
Reg 2 8 9 7
Reg 3 10 16 12

I am trying to write a formula that will give me the data for all three
regions for all months less than or equal to February (so Jan & Feb). But I
want the formula to look at all the months so that I can change my search
criteria for each month that passes.

Any help will be greatly appreciated!