View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kashish kashish is offline
external usenet poster
 
Posts: 18
Default Visit Calculation

My data as below,

Place Jan Fab Mar Apr
A 1,2 3 11,12 3
B 5 2 3
C 30,31 2 5 5,2
C 1 2 10 15
B 3 17,25 24 24
A 17 20 9,10 5

I want a formula for total visit

Place Total Visit
A 12
B 8
C 10