Hi there,

I'm using SUMIFS in Excel 2010. One of the columns the formula looks at has a whole number of accounts (identified by a number between 1000 & 8999). At times I would like to pull out only 4 or so of these accounts, but they're not always in sequence and there are other numbers in between. EG I would like accounts 3010, 4010, 5560 & 8800, but there are a number of accounts in between so cant use < or > or any of those easy ways. What would the syntax be for this please?

Is it something like this? (although I've tried this and it doesn't work!)

=SUMIFS($K:$K,$E:$E,"3010;4010;5560;8800")

Many thanks,

Michael