Formula help

[steelers777]

I made a fantasy football roster and score sheet for each player in our league. I want to be able to be able to keep scores of each player which I will do manually into the cells but I want to be able to designate which players are starters then have the starters points totaled up at the bottom of the page but I can't figure out a formula to do that.

For example, my roster may look like this

Favre 5
Roethlisber 7
James 8
Taylor 6

But I'm starting Roesthliberger and James therefore my Starter point total would be 13. How can I get the cells to calculate that automatically. Can I designate the points of the starters with a S in front of it. For example:

Favre 5
Roethlisber S7
James S8
Taylor 6

Would that do it then make a formula for that or can I color code the cells of the starters? Does this make sense.

Thanks for your help,
Kenny

 

[Scott Huish]

Hi, welcome to the board!

It would be much easier if you could use a seperate column for the S, then perhaps something like this:

Formula in E1:
=SUMIF(C1:C4,"S",B1:B4)

Book1
	A	B	C	D	E
1	Favre	5			15
2	Roethlisber	7	S
3	James	8	S
4	Taylor	6
Sheet1