EXCEL FORMULA ASSISTANCE

[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.

 

[Douglas J. Steele]

Sorry, but this newsgroup is for questions about Access, the database
product that's part of Office Professional.

You'd be best off reposting your question to a newsgroup related to Excel.