Sumif multiple criteria

[Pamella]

=SUM(SUMIF(B:B, {233,263,273,323,332,58,"XX","RR","EE","CC","6Y","KA"},D: D ))

Can put the bits in curly brackets into a cell where it can be maintained by the user?, instead of hard coding it in here?

[Bob Phillips]

You could put the values in separate cells, say M1, M2, …, and use


=SUM(SUMIF(B:B, OFFSET(M1,0,0,COUNTA(M:M)),D:D ))

[Pamella]

thanks xld