Hi,

If you had a working formula you would have been better posting it. Does
this help?

=IF(SUM(B4:M4)=1,"Do This",IF(SUM(B4:M4)=2,"Do That",IF(SUM(B4:M4)=3,"Do the
other","None of the above")))

Mike

"TheKickerDude" wrote:

OK I have the formula working correctly but I'm trying to use the sum
function to sum the cells B4:M4 and while in the IF statement instead of
typing
IF(B4+C4+D4 and so on.. like
IF(Sum(B4:M4 or something like that. I'm nesting like 4 other IF functions
into one cell. I just don't like the sight of a million characters in one
cell.
Any help? If not possible I will live with it I guess...