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

Sorry ignore A 12, B 8, c 10

I want total visit of A,B & C

"Mike H" wrote:

Hi,

Please explain how you got these results for A, B & C

Place Total Visit
A 12
B 8
C 10



Mike

"kashish" wrote:

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