Sumif unknown criteria

Hi all,

Is there any way how I can sumif/check if sums in Column B according every value in column A are equal to zero. There can be multiple different values in column A.

Column A:
y
x
z
z
z
y
x

Column B:
-1
1
1
0
-1
1
-1

Thanks for help!
Sandra

As ...

=SUMIF($A$2:$A$8,"y",$B$2:$B$8)

That's not exactly what's needed. The thing is that all available criterias in column A is unknown. I need somehow to sumif them all. That's part pf VBA code.

Wouldn't it then just be a plain old sum (to sum ALL the criteria) ?

=SUM($B$2:$B$8)

Thanks, but for this check in particular I need to make sure that sum is equal to zero according every separate criteria...;/

Maybe this in C2 and filled down

=SUMIF($A$2:$A$8,A2,$B$2:$B$8)=0

Yeah, that will perfectly do a trick! Thanks