I have this if statement:

=if(sum(e6=20040101:20040331),"1",if(sum(e6=200404 01: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!


--
Delaina
------------------------------------------------------------------------
Delaina's Profile: http://www.excelforum.com/member.php...o&userid=24151
View this thread: http://www.excelforum.com/showthread...hreadid=391959