SUMIF ? or similar function needed

[Jeff`]

Hi there,

I need a formula which will do this.

sumif(C1:200,multiple conditions,d1:100)

however multiple conditions don't appear to work in sumif.
the multiple conditions are Home Office offence codes so
they'll display codes either in the form "1","1A"
or "1/1". How could I pick these out?

 

[Frank Kabel]

Hi Jeff
try
=SUMPRODUCT((C1:C200={"1","1A","1/1"})*(D1200))

 

[Jeff]

Thanks Frank that's great!

Is there a way Instead of typing the multiple criteria
into the formula, can I have them typed into a cell
already and just reference the cell?

If so what format would I need it to be?

 

[Jeff]

Thanks Frank that's great!

Is there a way Instead of typing the multiple criteria
into the formula, can I have them typed into a cell
already and just reference the cell?

If so what format would I need it to be?

 

[Frank Kabel]

Hi
if you put your values in a ROW (e.g. M1:O1) try
=SUMPRODUCT((C1:C200=M1:O1)*(D1200))