EXCEL FORMULA ASSISTANCE

  • Thread starter Thread starter Toni
  • Start date Start date
T

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.
 
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.
 
Back
Top