=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?
=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?
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 ))
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
thanks xld
Reply With Quote
