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]

its ok mate

in what way was the results incorrect.

Dave

it turned up a blank where it should have turned up a 1

 

[SQUIDD]

what results to this give you copied down

BTW.

How is column C now relevent?
I dont think you have mentioned this part before and how that needs to intergrate with everything.

Dave

 

[SQUIDD]

I Get these results with dave in A1 in sheet2, results being in column F

[TABLE="width: 261"]
<tbody>[TR]
[TD]Column E[/TD]
[TD]Column F[/TD]
[TD][/TD]
[TD]Column H[/TD]
[/TR]
[TR]
[TD]bill[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]dave[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]bill[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]dave[/TD]
[TD]6[/TD]
[TD][/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]bill[/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]dave[/TD]
[TD]12[/TD]
[TD][/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]bill[/TD]
[TD][/TD]
[TD][/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]dave[/TD]
[TD]20[/TD]
[TD][/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]bill[/TD]
[TD][/TD]
[TD][/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]dave[/TD]
[TD]30[/TD]
[TD][/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]bill[/TD]
[TD][/TD]
[TD][/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]dave[/TD]
[TD]42[/TD]
[TD][/TD]
[TD]12[/TD]
[/TR]
</tbody>[/TABLE]

 

[Patcheen]

i didnt mention column c as i thought it would be possible with it but i must have been wrong so if a1 matches any the names in e2:e10000 and the date in c2:c10000 matches the date then it would surely return the result in "H"

 

[SQUIDD]

sorry mate

should have been a formula before my last post

=IF(AND('game data'!E1=sheet2!A$1,'game data'!H1>=1),SUMIF('game data'!E1:E$2,sheet2!A$1,'game data'!H1:H$2),"")

what results does this give you, i posted my results above.
are the results correct??

Dave

 

[Patcheen]

Game data sheet - https://s25.postimg.org/bu7be3cpr/data_2.png this is where the info is coming from

and this is the sheet where it all comes together - https://s25.postimg.org/cv7k37tpb/data_1.png and result in F4 Copied down

hope this makes it easier

 

[Patcheen]

sheet 2 does not exist it was only for example to make it easier

 

[SQUIDD]

ok

so you want total goals by james as time goes on.
my last formuala should do this for you no problem

so what is sheet 2 called??

dave

 

[Patcheen]

Player games

 

[SQUIDD]

so, what does this return
player games has your A1 data correct

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