View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
stacy stacy is offline
external usenet poster
 
Posts: 27
Default If I add v8 (Col A) and v8(col B), what formula to get v16(col c)

In a row the values would ranging from v4 to v8, how would I add all the
values that starts with v? So if col a would appear v8, column b would be v8
and column c would be s8, how will I add only the columns that starst with v?
Thus, I would need the sum in column f showing v16?