CODEWITHSUNDEEP
excelcriteriasumifs
Junior
Junior

Reputation: 1

Excel function - SUMIF/S with conditions

I have a column (A) with a list of numbers (let's say Customer Numbers), and a column B with balances. I need to sum column B with the condition that one particular Customer (let's say 001) is not taken into consideration when summing B column, and also that only negative balances from column B are summed.

I have tried with: =SUMIFS(B:B;A:A;"<>001";B:B;"<0") but it did not work.

Any ideas?

Upvotes: 0

Views: 117

Answers (1)

Dawid SA Tokyo
Dawid SA Tokyo

Reputation: 376

Try this =SUMIFS(B:B,A:A,"<>001",B:B,"<0")
I just replaced the ";" with "," in your formula and worked for me.

Upvotes: 0

Related Questions