# Sumif unknown criteria

1. ## 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

2. ## Re: Sumif unknown criteria

As ...

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

3. ## Re: Sumif unknown criteria

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.

4. ## Re: Sumif unknown criteria

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

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

5. ## Re: Sumif unknown criteria

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

6. ## Re: Sumif unknown criteria

Maybe this in C2 and filled down

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

7. ## Re: Sumif unknown criteria

Yeah, that will perfectly do a trick! Thanks

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1