SUMIF or HLookup

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!
 
L

Luke M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top