vlookup and sum???

[Tdp]

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.

 

[Barb Reinhardt]

How about something like this

=SUM(IF(LEN(A1:A15)>1,B1:B15))

Commit with CTRL SHIFT ENTER

 

[Barb Reinhardt]

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

=SUM(IF(ISBLANK(A1:A15)=FALSE,B1:B15))

 

[Pete_UK]

Or even:

=SUMIF(A1:A15,"<>",B1:B15)

No need for CSE.

Hope this helps.

Pete

 

[T. Valko]

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)