I have this if statement:

=if(sum(e6=20040101:20040331),"1",if(sum(e6=20040401:20040630),"2",if(sum(e6=20040701:20040930),"3",if(sum(e6=20041001:20041231),"4","not this year"))))

I am not quite a beginner, but I'm not an expert either. You can probably guess what I am trying to do..but if not, here's what I'm trying to accomplish.

If the sum of e6 equals any number from 20040101 to 20040331 then produce a 1 in the cell, if not, blah blah..you get it.

What am I missing?

Thanks!