Thing i would like to do in excel is this ..

I have a table with various numbers column and in another column are parameters describing these numbers. I want to sum all numbers which meet the required criteria .. something like this

numbers | parameter |

5 | B |

2 | B |

5 | A |

6 | D |

5 | A |

3 | B |

5 | A |

35 | C |

33 | B |

30 | C |

<tbody>

</tbody>

sum all numbers where parameters are A or C .. in another cell i want to sum all numbers where parameters are A, B, D.

I am not sure, if i am using wrong function or what .. SUMIF and SUMIFS works until I use one criteria like this

a) =SUMIFS(H1:H14; I1:I14; "A")

but when i add another criteria it shows zero

b) =SUMIFS(H1:H14; I1:I14; "A"; I1:I14; "B")

My questions are:

What and how to use to get results a want ?

Is there a way how to add multiple criteria in one criteria range ? When you look on (b) .. its waste of time and space to define criteria range for every new criteria when the range is not changing.

thank you for help and explaining !