Not calculating

[Patcheen]

why is this not calculating?

=IFERROR(SUM('Game Data'!$E$2:$E$10000,$A$1,'Game Data'!$H$2:$H$10000,"=>1"),"")

"E" is list of names that match "A1" and "H" is numbers greater or equal to 1

 

[Patcheen]

blank - is it poss on game date to go from e2:e10000 instead of just e1? etc i appreciate your l help

it all starts from e2 h2 etc as row 1 is headers

 

[SQUIDD]

Looking at your example

it looks like you need your results in column H?

and the goals to sum is in column D?

try this copied down

=IF(AND('game data'!E1='Player games '!A$1,'game data'!D1>=1),SUMIF('game data'!E1:E$2,'Player games '!A$1,'game data'!D1:D$2),"")

 

[Patcheen]

Looking at your example

it looks like you need your results in column H?

and the goals to sum is in column D?

try this copied down

=IF(AND('game data'!E1='Player games '!A$1,'game data'!D1>=1),SUMIF('game data'!E1:E$2,'Player games '!A$1,'game data'!D1:D$2),"")

this is raw data where sheets depend on it for all calculations this sheet cant be touched except to input raw data for other sheets that is where player games come in this sheet gets the info it needs from game data - result should be in player games "E3" copied down

 

[SQUIDD]

my results, formula copied down in Gls column

[TABLE="width: 325"]
<colgroup><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD]Goal(s)[/TD]
[TD]Player[/TD]
[TD][/TD]
[TD][/TD]
[TD]Gls[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]james[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]james[/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]james[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]

 

[Patcheen]

k but i need it to calculate in the player games sheet as row 1 in game data is headers

 

[SQUIDD]

formula
for row 2 and copy down, are the results above correct?

=IF(AND('game data'!E2='Player games '!A$1,'game data'!D2>=1),SUMIF('game data'!E$2:E2,'Player games '!A$1,'game data'!D$2:D2),"")

because i put the sheet names in everywhere, you can use the formula in any sheet

Dave

 

[Patcheen]

formula
for row 2 and copy down, are the results above correct?

=IF(AND('game data'!E2='Player games '!A$1,'game data'!D2>=1),SUMIF('game data'!E$2:E2,'Player games '!A$1,'game data'!D$2:D2),"")

because i put the sheet names in everywhere, you can use the formula in any sheet

Dave

i copied down and it turned them all up blanks maybe if we implement the date column just an idea i thank you for all your valuable help

 

[SQUIDD]

ok, but was my data i posted calculating correctly?

dave

 

[Patcheen]

ya think so but blanks,,,,, sorry

 

[SQUIDD]

if my results posted above works, but you get blanks.
Im thinking you may have a data format issue on your sheet.

what are the results if you put this formula anywhere in your workbook.

=IF('game data'!E4='Player games '!A1,"true","false")

check E4 has a name, if not change the formula E4 to E? whateve cell contains the name james

dave