Hello

Hoping someone can help. I'm working with some data and want to use something similar to SUMIF, but want to count certain criteria but exclude others. Let me try and give an example

My 2 columns may look something like the following where column A is my result code and B is the volume.

A B
IX1N 12
IX1S 21
ICON 8
ICPP 2
IX2N 26
IX2S 5
IXAS 65
IXEN 14
IXES 15
ISN3 4
ISJP 20


For the purposes of this I'm going to use the ? symbol as a single character wild card. What I would like to do is count anything that is IC?? or IS?? but then to exclude anything that is ICP? ISN? or ICON

Can anyone help please.

Thanks