How to total separate words formula

[DODGE]

Hi All
I have a column that displays the word DOORS AND DRAWERS randomly down the column.
Each cell would display either the word DOORS or DRAWERS, not both words in one cell.
I want to have a separate total of each, eg the total of the word Doors and the total of the word Drawers. Not sure if this is a SUMIF type of formula or what.
Thanks for your help guys.
Dodge

[Rahul Nagar]

Hi

Use Count function.
if your data is in A column paste this formula in B Column =COUNTIF(A:A,A1)

[DODGE]

Hi

Use Count function.
if your data is in A column paste this formula in B Column =COUNTIF(A:A,A1)

Thanks for your help but not sure what you mean.
The words DOORS & DRAWERS will appear randomly in each cell down ONE column
Such as:
DOORS
DRAWERS
DOORS
DOORS
DRAWERS
DRAWERS
I need to count the number of times DOORS appears and DRAWERS appears EG:
TOTAL: DOORS
TOTAL: DRAWERS
Not sure of the formula for this, I can’t get anything to work.
Cheers Dodge

[zbor]

Write in E1 DORRS
Write in E2 DRAWERS

In F1 write =COUNTIF(A:A, E1)
And pull formula down

[DODGE]

Write in E1 DORRS
Write in E2 DRAWERS

In F1 write =COUNTIF(A:A, E1)
And pull formula down

Still not sure how to do it.
The words DOORS & DRAWERS will appear down one column from Q10 to Q50.
I just need to total these seperatly at the bottom in Q51 Not sure where F1 and E1 and E2 are coming from.
Can you step me through it in laymans terms I'm not very good with the program.
Many Thanks
Dodge

[zbor]

If you expect example maybe you should write one and I will gladly write formula in it.

To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

In example write your input and desired output.

[abousetta]

Maybe in Q51 put this formula:

Please Login or Register  to view this content.

abousetta

[DODGE]

Maybe in Q51 put this formula:

Please Login or Register  to view this content.

abousetta

Thanks Abou
That did the trick.
Cheers Dodge