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

 

[SQUIDD]

Ok

so tell me

are you after counting the number instances progressivly then.

like this, john is in A1. Below is column E, H and the rwsults

bill 2 0
jo 5 0
john 9 9
jo 2 0
john 2 11
bill 7 0
john 3 14

??

dave

 

[SQUIDD]

If I am correct with my last post.

TRY this

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

and copy down in your desired column.

this only sums the the numbers from column H if E matches A1 and H is >=1 up to the point of the row with the formula in.

Giving you at sum of all true critera to that point

Maybe what you want??

Dave

 

[Patcheen]

Sorry guys fell asleep trying them now

 

[Patcheen]

Ok

so tell me

are you after counting the number instances progressivly then.

like this, john is in A1. Below is column E, H and the rwsults

bill 2 0
jo 5 0
john 9 9
jo 2 0
john 2 11
bill 7 0
john 3 14

??

dave

This looks correct but now to put it to work

 

[SQUIDD]

ok

let me know how it goes.

dave

 

[Patcheen]

no man still no joy im sorry for bugging you

 

[Patcheen]

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

mine has to have e1:e10000 and h1:h10000

E1 must match A1

maybe if i put in an date column which would be more confusing but maybe possible i have that as is only to include date to make it all match up?

 

[SQUIDD]

its ok mate

in what way was the results incorrect.

Dave

 

[SQUIDD]

as you copy the formula down

all the 1's will change in the copy down formulas

 

[Patcheen]

2 sheets -

1st sheet Game Data -

Column E2:e10000 is names

Column C2:c10000 is dates

Column H2:h10000 is numbers

------ Sheet 2

Cell a1 is the selected name to match the name in sheet 1 column e2:e10000

column "b" is the dates which will match the revelant date in sheet 1 column C2:c10000

so if the date and cell from sheet 2 match the criteria in sheet 1 it should give the number in the relevant cell of "H" an subsequently add them up as it enter counters more

Hope this makes more sence