Hi,

the comma is a list separator which is a local Windows setting
(regional and language settings). Try replacing it with a semicolon or
lookup your settings in Windows.

For multiple selections I have set up a simple example below:

Data in A2:B10
Selection criteria in E2:I2
Total in D3
Formulas in E3:H3

group numbers total cond1 cond2 cond3 cond4 insert new cols bevor this
green 32 green red yellow magenta no entry
magenta 16 219 32 45 103 39
magenta 23
red 12
red 33
yellow 6
yellow 53
yellow 44
add rows before this

Formula in D3: =SUM($E$3:$I$3)
Formula in E3: =SUMIF($A$2:$A$10;"="&E$2&"";$B$2:$B$10)
Copy formula in E3 to F3:H3

Mind that the ranges are fixed which means that for new rows with data
insert the number of lines required befor the row that reads "add rows
before this". This line is included in the range.
Similarly add columns for additional conditions before the column that
reads "insert new cols before this" because this column is included in
the range. If you insert new conditions don't forget to copy the
formula from the preceding cell into the new ones.

If this still isn't the solution please come back.

Hans