Can anyone advise on a better way of expressing this formula?

All I want to do is sum entries in a column where the criteria is between
L1DAYS and L13 DAYS (inclusive).

I assume that I need some sort of SUMIF(AND but I can't figure it out


=SUMIF($H15:$H365,"L1DAYS",P15:P365)+
SUMIF($H15:$H365,"L2DAYS",P15:P365)+
SUMIF($H15:$H365,"L3DAYS",P15:P365)+
SUMIF($H15:$H365,"L4DAYS",P15:P365)+
SUMIF($H15:$H365,"L5DAYS",P15:P365)+
SUMIF($H15:$H365,"L6DAYS",P15:P365)+
SUMIF($H15:$H365,"L7DAYS",P15:P365)+
SUMIF($H15:$H365,"L8DAYS",P15:P365)+
SUMIF($H15:$H365,"L9DAYS",P15:P365)+
SUMIF($H15:$H365,"L10DAYS",P15:P365)+
SUMIF($H15:$H365,"L11DAYS",P15:P365)+
SUMIF($H15:$H365,"L12DAYS",P15:P365)+
SUMIF($H15:$H365,"L13DAYS",P15:P365)+
SUMIF($H15:$H365,"L14DAYS",P15:P365)

Thanks for anyone's help

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200706/1