Macro for total entries in excel sheet with break up

[peermsk]

Good day
i have an Excel Sheet consisting of below columns:
Wk A B C D E
Location Company Document Ref no Status
49 Muscat Sharaf Exp Visa 1234 on hire
49 Sohar Merchant Visit visa 4321 offhire
50 Salalah Star Transit 5678 leave
50 Sur Sharaf Crew Visa 9876 Joining
51 MAF Merchant Crew Visa 9898 Sick

Summary
Muscat Sohar Salalah Sur MAF Total

Week 49 1 1 2
Week 50 1 1 2
Week 51 1 1

Grant Todal 1 1 1 1 1 5

i need the total row wise and column wise to change automatically , when i add data in the rows for week 51 or Week 52 or week 53 week 54
every time i add data totals should change.
Kindly give some Macro/VB or conditional formating solution if any

 

[frabulator]

Are you looking for a SUM function?

Its pretty simple. Inside the cell that you want your total to be type

=SUM(

and then select your range you want to gather data from. Once the range is selected close the bracket with another...

)

and hit enter.

You should have something like this:

=sum(F2:F9)

Which will give you the total of all your selected cells.

 

[peermsk]

No pls find below my file and and how the totals should be

Sea Crew

1289175708

REDDIARPET GODHANDAPANI MANIMARAN

J4716567

INDIA

MT SUN PLOEG

20.11.2016

SOHAR

SHARAF

GODHABDAPANI

ON

مهندس

Express visa

1288474203

KUNDNANI HARESH UTTAMCHAND

Z2364834

INDIA

OTHER

20.11.2016

OTHER

SHARAF

SURIBAI

ON

مهندس

Express visa

1290736807

GIOVANIS PANAGIOTIS

AN3232223

GREECE

MSC POSITANO

22.11.2016

SALALAH

SHARAF

PANAGIOTIS

ON

رجل أمن

Express visa

1290734411

CHRISTOS MOUSTAKAS

AM1777644

GREECE

MSC POSITANO

22.11.2016

SALALAH

SHARAF

PANAGIOTIS

OFF

رجل أمن

Express visa

1290813410

ABHICHANDANI YOGESH RAMESH

P1768384

INDIA

MSC FANTASIA

22.11.2016

MUSCAT

SHARAF

CHANDRA

ON

مدير عمليات

This week up to 22.11.2016 - Total 6 (Year Total 1716 visas)

No. of Visa

Muscat

Salalah

Sohar

Sur

Other’s

Total

Budget

Variance

Last Week

1

2

2

0

1

6

30

-24

Year to date

351

784

419

146

16

1716

1410

306

<colgroup><col><col><col span="11"></colgroup><tbody>
</tbody>

Are you looking for a SUM function?

Its pretty simple. Inside the cell that you want your total to be type

=SUM(

and then select your range you want to gather data from. Once the range is selected close the bracket with another...

)

and hit enter.

You should have something like this:

=sum(F2:F9)

Which will give you the total of all your selected cells.

 

[WarfritLive]

Like this?

 

[peermsk]

Like this?

No sir
every time i add a data - i mean a next line based on the location quantity should be added automatically and total subtotals too change automatically
say for example i add a data which shows location Sohar then in he below summary under Sohar 1 number to add and right side total to increase with 1
and column wise total too increase with 1