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]

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?

I'm not sure how your data looks or what you want from that data. Can you share a small sample of your data as well as the desired output?

You can use this: http://www.mrexcel.com/forum/about-board/508133-attachments.html
Or upload a picture to an image sharing website
Or simply copy and paste a small sample of data into the comment box here.

 

[Patcheen]

thank you but not quiet there i need something like this

if poss

=IF(AND('Game Data'!e2:e10000,$A$1,'Game Data'!H2:h10000>=1))

 

[SQUIDD]

Im a bit lost to what you want.

did you not want to copy the formal down?

 

[Patcheen]

i want it to add the number in "H" and what it finds to the previous number for the name in "a1" all data from data sheet.... ill try post pic in 20 or so

 

[Patcheen]

in data sheet -

column e2:e10000 james column h2:h10000 is 1

column e2:e10000 james column h2:h10000 is 2


om other sheet when james is selected in a1 it should in column "F" should be 1 and when it finds the 2 from then it adds this to 1 to become 3 and if it find nothing leave blank the it finds it in the next row an so on

 

[SQUIDD]

hmmm

sorry mate, youve lost me, can you post a screen shot of your data.

showing your data layout, where you want the formulas and what the formula needs to return

dave

 

[Patcheen]

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

what i want is to sum up what it finds in "H" for the name in "E" that matches A1 from the game data sheet.

im not the brainiest with excel but i thought this was easier than its turned out to be ahhhhhhh

sorry for the confusion to you all

 

[SQUIDD]

So

columns H has numbers.
Column E has names

you only want 1 formula, you are not copying down etc.

the formula should sum every number in coulmn E when H matches A1.

correct?

Dave

 

[Patcheen]

Correct

 

[Patcheen]

sorry it is copying down sorry i mis-read