# a sum based on other fields.

Hello,

I have a large sharepoint list. Within an excel file data connection to this list.
In this excel i have created a table were all data is in.

Based on the value's of some of the field i want to make some calculations.
For example, from the table below i would like to know the total revenue of month 1 for all customers expect c.
Is there anyway do this?

month      revenue      customer
1       € 10,00       a
1       € 20,00       a
1       € 25,00       b
1       € 40,00       c
2       € 50,00       a
2       € 1,00       a
2       € 4,00       b
2       € 182,00       c
Subodh Tiwari (Neeraj)

membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.

Im getting this:

what am i doing wrong?

AH =SUMIFS(B:B;A:A;1;C:C;"<>c")

thanks aloT!
What do use as a separator in the formulas, a comma or a semicolon?
If you use a semicolon, replace all the commas with a semicolon.
b
Btw I have logged off and on mobile now.