Countif Questions

[Killer17]

Hey all need some help if creating a formula that will give me the correct totals in each cell

If cell E5:I8 = GBO, DUM, DEC, ABS count cell D1
If cell E5:J8 = blank count cell F5:J8

I'm trying to achieve the total in each cell I have created an example of what I'm trying to achieve.

Thanks

Excel Workbook
	A	C	D	E	F	G	H	I	J	K
1			190
2
3
4	Name				Game 1		Game 2		Game 3	Total
5	Joe				127		102		128	357
6	Martin			dec	153		143	dec	115	523
7	Hendy				138	abs	186		111	439
8	Stuart				139		166	gbo	138	495
9
10			If cell E5:J8 = GBO, DUM, DEC, ABS count cell D1
Sheet1

Excel 2007

 

[Scott Huish]

Are you SUMming or COUNTing? What is the expected result from your sample?

 

[Killer17]

I'm trying to get a summing total

 

[Killer17]

I hope this makes it more clearly in trying to archive the formula.

Excel Workbook
	A	E	F	G	H	I	J	K	L	M	N	O
1		190
2
3	Player's Name	IND	Game 1	IND	Game 2	IND	Game 3	Total	1
4	Karen	abs	127		102		128	420	2
5	Martin		153		143	abs	115	486	3
6	Ian	dum	138	dum	186	dum	111	570	4
7	Stuart	dec	139	gbo	166		138	518	5
8
9	1	example: E4 = Abs count cell E1 + G4 = blank count cell H4 + cell I4 = blank count cell J4 = 420 in Cell K4
10	2	example: E5 = blank count cell F5+ cell G5 = blank count cell H5 + J5 = abs Count cell E1 total of 486 in cell K5
11	3	example: E6 = dum count cell E1 + G6 = DUM count Cell E1 + I6 = dum count E1 total in cell K6 = 570
12	4	example: E7 = DEC count cell e1 + G7 = GBO count cell E1 + cell I is blank count J7 for total in cell K7 of 518
13
14	If any cells E4:E7, G4:G7, I4:I7 = GBO , DEC, DUM, ABS count cell E1
15
16	If any cells E4:E7, G4:G7, I4:I7 dount have GBO , DEC, DUM, ABS count the actually number in each cell across for totals
17
Sheet1

Excel 2007