vlookup and sum???

  • Thread starter Thread starter Tdp
  • Start date Start date
T

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.
 
How about something like this

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

Commit with CTRL SHIFT ENTER
 
Sorry, my original solution didn't work. Try this one

=SUM(IF(ISBLANK(A1:A15)=FALSE,B1:B15))
 
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)
 
Back
Top