On Jun 6, 11:23 am, "Francois via OfficeKB.com" <u18959@uwe wrote:
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.comhttp://www.officekb.com/Uwe/Forums.aspx/ms-excel/200706/1
try:

=SUMPRODUCT(--($H15:$H365="L1Days"),--
($H15:$H365<="L13Days"),P15:P365)