View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tdp Tdp is offline
external usenet poster
 
Posts: 74
Default vlookup and sum???

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