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]

how do i get this to sum up as it finds the numbers? the numbers are in H2:h10000 -

this is an Array formula =IFERROR(COUNT(IF('Game Data'!$E$2:$E$10000='Player games'!$A$1,IF('Game Data'!$C$2:$C$10000='Player games'!B4,'Game Data'!$H$2:$H$10000))),"") this only give me the number it finds so if it finds a 1 and then another 1 it give me a 1 instead of 2

 

[Patcheen]

any ideas?

 

[SQUIDD]

i thought the formula worked
sums them as it finds them.

i really not sure i can help any further, sorry mate.

dave

 

[Patcheen]

it dont add them up with sum only gives me the original number