sumif mulpitle criteria

[psrs0810]

I want to do a sumif the values equal 1, 5 and 102 - how do I do a sumif with all three?

Thanks

 

[Firefly2012]

Hi

Try:

=SUM(SUMIF(A:A,{1,5,102}))

which will add all the 1s, 5s and 102s in the A column

 

[Akashwani]

Hi,

You could also try SUMPRODUCT.......

Excel Workbook
	A	B	C	D
1	Data1		Result
2	1		324
3	5
4	102
5	1000
6	1
7	5
8	102
9	1000
10	1
11	5
12	102
13
Sheet1

I hope that helps.

Ak