can you imbed a sumif

[Lori]

is this possible sumif(a:a,x2,sumif(h:h,y2,j:j))
I have multipul criteria with in multiple criteria
12 joe 25
12 joe 10
12 sue 5
13 joe 18
13 joe 20
13 joe 14
13 sue 19
13 sue 25
14 sue 19

 

[PCLIVE]

Use SUMPRODUCT. You have to specify a range with this.
=SUMPRODUCT(--(A2:A100=X2),--(H2:H100=Y2),J2:J100)


HTH,
Paul