• 466K Members
• 10.3K Online
• 564K Conversations
SOLVED

## Excel formula help

Occasional Contributor

# Excel formula help

Trying to create a formula that will sum a dollar amount from another worksheet in the same workbook while filtering two types of criteria.

=SUM(Table1[MRR]) /COUNTIFS(Table1[Status], "red", Table1[Primary CSEP Identification],"<>Contract Renewal - within 3 months")

The sum is supposed to be the total, the status identified as red and excluding Primary CSEP identification of contract renewal. What am I missing?

4 Replies

# Re: Excel formula help

You have not applied any filtering to the summation which I assume to be the point of the exercise.

=SUMIFS(Table1[MRR]), Table1[Status], "red", Table1[Primary CSEP Identification],"<>Contract Renewal - within 3 months")

Highlighted

# Re: Excel formula help

Thank you for your reply and help. I tried this formula during this process and again with your comment, however I recieve an error back stating "You've entered too few arguments for this function".

Solution

# Re: Excel formula help

Then I assume you have not actually provided the 5 parameters as suggested.

Check carefully that you have conformed to the syntax

=SUMIFS(

Table1[MRR]),  {the range to be conditionally summed}

Table1[Status],   {the first criterion range}

"red",   {the value you required for the first criterion}

Table1[Primary CSEP Identification],  {the second criterion range}

"<>Contract Renewal - within 3 months")   {the value you required for the second criterion}

with commas separating the arguments.

# Re: Excel formula help

Thank you Peter, I have tried this formula many times but when you broke it out like that I re-wrote it, as you spelled out. This worked!! I must've missed a comma somewhere or something small since I have been looking at it for 3 days :).

Very much appreciate your help and walking me through it!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies