Counting letters instead of numbers

[Marvo]

I've got this formula

=SUM(OFFSET(ALL!J304,,,managers!$AA$2))

that counts up the numbers in Column J.

What I'm wondering is if its possible to change this to count up instead the Letter "W"? Maybe COUNTIF?

What would be even better if possible would be to also count "D" and "L" which also occur in the same column.

Tricky one this for me, any help much obliged.

[alansidman]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Marvo]

My workbook is too big, nearly 3000kb. Its all connected, not sure I can do what you ask. I'll have a go and see.

[:) Sixthsense :)]

For Counting Multiple Text

=SUM(COUNTIF(OFFSET(ALL!J304,,,managers!$AA$2),{"W","D","L"}))

For Counting Single Text

=COUNTIF(OFFSET(ALL!J304,,,managers!$AA$2),"A")

[Marvo]

For Counting Multiple Text

=SUM(COUNTIF(OFFSET(ALL!J304,,,managers!$AA$2),{"W","D","L"}))

For Counting Single Text

=COUNTIF(OFFSET(ALL!J304,,,managers!$AA$2),"A")

Thank you. That works a treat. I'm very grateful (to both of you).