Applying an IF formula to an entire Column?

[Atrabado]

Hey guys I have a project I am doing, but I have so many people who joined I was wondering if it there is a way to assign a formula to an entire Column?

For example:
I have a row with the following data:

1

W

L

T

L

T

L

W

W

<tbody>
</tbody>

Lets say I have around 500 of these rows with the data random.

I want to assign a formula to the columns for example column B:
If the column B has Value "W" assign it to 1 if not 0.

Also is there a way I can once I apply those formulas. How do I add those new values at the end on a new column?

Thanks for the Help I'm new to Excel and any help would be appreciated.

-Atrabado

 

[konew1]

Try in B502=COUNTIF(B1:B500,"W")
If you want more flexibility you can put "W" in a cell somewhere and refer to the cell

 

[Atrabado]

Try in B502=COUNTIF(B1:B500,"W")
If you want more flexibility you can put "W" in a cell somewhere and refer to the cell

Okay that seemed to work! How would I make it so if I made a new column to add the numbers now?

 

[konew1]

Your question isn't clear to me.
If you want to count "W" in two different columns, with the result in the same cell then

If the columns are adjacent and you only want to count "W" =COUNTIF(B1:C500,"W")
or if they are not adjacent then COUNTIF(B1:B500,"W")+COUNTIF(K1:K500,"W")
or if you want "W" in one column and "X" in anther
COUNTIF(B1:B500,"W")+COUNTIF(K1:K500,"X")

Just re-read your posting...maybe you just need to copy from B502 and paste in row 502 of another column???