Sorry, my original solution didn't work. Try this one

=SUM(IF(ISBLANK(A1:A15)=FALSE,B1:B15))
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Tdp" wrote:

I have the following:
cells A1:A15 has names (but can be blank)
Cells B1:B15 has values

How do I sum col B1:B15 values only if there are names in cells A1:A15.

--
Tdp