EXCEL ENQUIRY

[Toni]

Hello,

I would be most grateful if someone could help me to create a formula in
Excel to add text. Please see below what I need to achieve:

1- I need to have a formula that add all the "Yes" contained in an Excel
column in Sheet 1 and have the total of all the "YES" (In numerical form) in
Sheet 2, hence I also need a formula that link Sheet 1 to Sheet 2 of the
same Excel spreadsheet.

A

TEXT SENT

1 YES
2
3 YES
4
5 YES
6 YES
7 YES
8
9
10 YES


2- Also, I need to have a formula that add separately all the "PL" "PY" "RG"
"RY" "ZD" contained in an Excel column in Sheet 1 and have the total in
Sheet 2, hence I also need a formula that link Sheet 1 to Sheet 2 of the
same Excel spreadsheet.

A

BOROUGHS

1 PL
2 PL
3 RG
4 RG
5 ZD
6 ZD
7 RG
8 PL
9 RG
10 RY


2a. I than need to add the individual total of each "PL" "PY" "RG" etc.
gathered on sheet 1 of an Excel spreadsheet and have the totals (in
numerical form) of each alphabetical letters ("PL" "PY" "RG" etc.) on
sheet 2 of the same Excel spreadsheet. See Example below:

A B C
PL PY RG
TOTAL 6 5 10

That's all. Please note that I have virtually no knowledge of Excel itself
and IT in general, hence I would appreciate if you could assist me with the
above query.

Thank you very much in advance for your help and assistance.

Regards,

Toni.

 

[Bob Phillips]

Sounds like pivot tables will do all that you want. Take a look at

http://www.cpearson.com/excel/pivots.htm

http://edferrero.m6.net/Pivot.html

http://it.fuqua.duke.edu/public/2001PivotTableIntroduction.pdf

http://peltiertech.com/Excel/Pivots/pivotstart.htm

http://www.contextures.com/xlPivot01.html

http://www.datapigtechnologies.com/flashfiles/pivot1.html