Here's another one...

This will sum only those entries that are text and excludes formula blanks
if they might be present:

=SUMIF(A1:A15,"?*",B1:B15)

--
Biff
Microsoft Excel MVP


"Tdp" wrote in message
...
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