CODEWITHSUNDEEP
excelsumifs
fmm
fmm

Reputation: 1

Using SUMIFS to ignore a negative number

I've seen a few solutions to this problem using SUMIF to ignore a negative number, however, I need to use SUMIFS for this particular issue.

My SUMIFS function is somewhat simple

=SUMIFS(A:A,B:B,B1)

Where I just want to sum all of the values in column A based on a descriptor in column B. However for some of my column A values are negative and I need this to be excluded from the summation.

Upvotes: 0

Views: 3163

Answers (2)

cybernetic.nomad
cybernetic.nomad

Reputation: 6368

Does something like 

 =SUMIFS(A:A,B:B,B1, A:A ">" & 0)

work for you?

Upvotes: 0

Scott Craner
Scott Craner

Reputation: 152505

Add that criteria:

=SUMIFS(A:A,B:B,B1,A:A,">0")

Upvotes: 0

Related Questions