SUMIF or HLookup

  • Thread starter Thread starter Denise_NOLA
  • Start date Start date
D

Denise_NOLA

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!
 
It can, if you if you set it up using a date. For instance, use dates of 1/1,
2/1, 3/1, etc..., and format cell as:
mmm

to get your desired look. Now XL can easily do a "less than x, more than y"
type of formula.
 
Back
Top