unable to get formula to work

[Patcheen]

what is wrong with my formula i keep getting an error

=COUNTIFS('Game Data'!E$2:E3,='Shirt Database'!A3,'Game Data'!H3)

im trying to calculate if Game Data'!E$2:E3 = Shirt Database'!A3 and if thats correct then return the answer in Game Data'!H3

thank you for your help

 

[Patcheen]

that works but not what i though it was as i forgot to include something for arguments sake can you see my sample file to see what im trying to achieve - thank you

 

[jtakw]

OK, you got something strange going on with your Excel.
The formula in D2 below WORKS correctly, HOWEVER, if you just copy down the formula, it will only PASTE value instead, UNLESS, after you copied the formula down column, THEN, go into each formula cell and hit ENTER, THEN it will correct itself.
You may have a corrupt file.

See C11:C15 and D11:D15, simple math, I copied formula down from D11 to D15, it only show the D11 value.

Excel 2010
	A	B	C	D	E
1	10		Cell A1 has data valadation
2	Harry	Other data		4
3	Tom			4
4	John			35
5	Paddy			10
6
7
8
9	A1 is a drop down menu
10
11			1	3
12			2	3
13			3	3
14			4	3
15			5	3
other data

Cell Formulas
Range	Formula
D2	=SUMIF('Game Data'!E$2:E$19,A2,'Game Data'!H$2:H$19)
D11	=C11+C12
D12	=C12+C13
D13	=C13+C14
D14	=C14+C15
D15	=C15+C16

 

[jtakw]

Had another look at your workbook, it turns out you had Formula Calculations on Manual, don't know if that's intentional on your part.

So the formula as posted above in D2 should give you what you're looking for, I'll post it again:

Excel 2010
	A	B	C	D
1	4		Cell A1 has data valadation
2	Harry	Other data		4
3	Tom			4
4	John			35
5	Paddy			10
6
7
8
9	A1 is a drop down menu
other data

Cell Formulas
Range	Formula
D2	=SUMIF('Game Data'!E$2:E$19,A2,'Game Data'!H$2:H$19)