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]

any other ideas to get the correct result?

 

[SQUIDD]

Hi Patcheen

check your PM mate

I will have another look for you tomorrow.

Dave

 

[Patcheen]

K thank you so very much for your help.

check e-mail as i just sent the file

thank you

 

[SQUIDD]

just looking at this for you now

dave

 

[Patcheen]

thank you

 

[SQUIDD]

Patcheen

So, just to be sure, you want your formula in sheets "Game Data" column "D". Correct?
And the results in column D should display the sum of goals scored by the player from sheets "Player Games" cell "A1" up until the point where this formula is?

like this if the name was dave, results of formula in ""

john 2 "blank"
dave 1 "1"
john 3 "blank"
dave 3 "4"

like this if the name was john, results of formula in ""

john 2 "2"
dave 1 "blank"
john 3 "5"
dave 3 "blank"

correct??

Dave

 

[SQUIDD]

Also

do me a favour.

When i open your file, calculation is set to MANUAL and not AUTOMATIC

I assume when you have been using my formuals this was in fact set to AUTOMATIC???

this works for me after calculation is set to AUTOMATIC

=IF(AND('Game Data'!$E2='Player games'!A$1,'Game Data'!$H2>=1),SUMIF('Game Data'!$E$2:E2,'Player games'!A$1,'Game Data'!$H$2:H2),"")

try this

will send new file

dave

 

[Patcheen]

Just Back........

 

[Patcheen]

works a treat if the person is in e2 but for example the person in such a large database in e8336 it wont work for unless i change e2 to e8366 see below -

From -
=IF(AND('Game Data'!$E2='Player games'!A$1,'Game Data'!$H2>=1),SUMIF('Game Data'!$E$2:E2,'Player games'!A$1,'Game Data'!$H$2:H2),"")

To -
=IF(AND('Game Data'!$E8366='Player games'!A$1,'Game Data'!$H8366>=1),SUMIF('Game Data'!$E$8366:E8366,'Player games'!A$1,'Game Data'!$H$8366:H8366),"")

i would have to change this for each player search

 

[Patcheen]

This sums up in total
SUMIF('Game Data'!$E:$E,$A$1,'Game Data'!$D2:$D10000)

But when i add this it says my formula contains an error
SUMIF('Game Data'!$E:$E,$A$1,'Game Data'!$D2:$D10000),'(game data'!C:C,'Player games'!b4)

C2:c10000 is the date range (Game data)

E:E is the player range (GAme data)

A1 in player games is the player (Player games

b4 in player games is date drag down it checks the next datethe next date

hope i forgotten nothing