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

 

[63falcondude]

What do you mean by "not calculating"? What happens when you hit Enter after typing in the formula?

Is that formula supposed to be a SUMIFS formula?

 

[Patcheen]

it gives me a blank and with with sumifs it say you've entered too few arguments for this function

 

[63falcondude]

it gives me a blank

It gives you a blank because the formula is resulting in an error. The "" at the end of the IFERROR formula is doing this. What does the following formula give you?

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

 

[Patcheen]

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

gives me #Value

 

[63falcondude]

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

gives me #Value

Sorry, my mistake. I'm surprised it let you put that formula in at all... If you want to sum the numbers in column H (where the values in column E match the value in A1 and the numbers in column H are > = 1), try

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

 

[Patcheen]

that gives me the total and not sum individually example

Name - Number

james - 1

James - 0

James -1

is it poss for me to post a screen shot?

 

[SQUIDD]

you want something like this??

=IF(AND(E3=$A$1,H3>=1),H3,"")

Dave

 

[Patcheen]

not sure as it has to get the data from the game data sheet

 

[SQUIDD]

yep, sorry, missed that.

=IF(AND(E3='Game Data'!$A$1,'Game Data'!H3>=1),'Game Data'!H3,"")

dave