ExcelBanter - can you imbed a sumif

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - can you imbed a sumif (https://www.excelbanter.com/excel-worksheet-functions/188581-can-you-imbed-sumif.html)

Lori

can you imbed a sumif

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

can you imbed a sumif

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

HTH,
Paul

--

"Lori" wrote in message
...
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

All times are GMT +1. The time now is 03:24 PM.