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