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

Visit Calculation
 

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

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