condensed mirror image

[timestwo]

is this possible please??

I have a worksheet (A), which is updated daily, with the following on :-

Acclamation" 2 2 2 2 1
Acclamation# 21 43 19 15 7 7 2 1 2 1
Acclamation* 16 44 21 9 1 3 1 1
Acclamation; 20 28 23 10 2 2
Ad Valorem" 1 2 1
Ad Valorem# 1 5 1 8 1
Ad Valorem* 1 3 1 1 1 1
Ad Valorem; 1 6 3 4 4 1
Alhaarth"
Alhaarth# 5 3 2 1 1
Alhaarth* 3 1 5 2 3 1 3
Alhaarth; 2 3 3 2 13 2 3 2 1 1

and wondered if it was possible to have another worksheet (B), looking like this :-

Acclamation 57 117 65 36 12 13 0 2 0 1 1 2 2
Ad Valorem 3 9 7 11 5 8 0 2 0 2 0 0 0
Alhaarth 0 10 7 10 4 17 3 7 2 1 0 1 0

which updates automatically, when data is entered in to worksheet (A).

Any solution would be most welcome

 

[Deepak]

Hope,

You are looking something like as this.
If not then pls share the sample workbook.

=SUMIF(Sheet1!$A:$A,$A1,Sheet1!B:B)
Where A1 is "Acclamation*".