Can't figure out formula.

Can someone help me? I would like to add whatever is in cells A1 – D1, (in this
case, cell content total is 4) and if cell E1 has a value, combine them in cell
F1 to look like this, "4 + 1".

=COUNT(A1:D1),IF(E1," + ","")

I know this formula does not work. It's just to give you an idea of what I’m trying
to do.

Matt

Try this formula in F1: =SUM(A1:D1)&" + "&E1. If E1 is blank, F1 will be 4 +. If E1 is 0, F1 will be 4 + 0 (as a zero is still a value). Note space either side of +.

Originally Posted by duane

try

=IF(ISNUMBER(E1)=TRUE,CONCATENATE(SUM(A1:D1)," + ",E1),"")

Ya, as far as I'm conserned your an expert. I subtituted COUNT for SUM and it works greate. Thanks!