Formula Help

Lisa Welch · 10/04/22

I have 2 columns.

Annual Estimated Savings ($)
Confidence (25%, 50%, 75%, 100%)

I need a formula that will total the value from column 1 each time 25% is chosen etc. from the amounts in "Annual Estimated Savings"

Lisa Welch · 10/04/22

Perfection!! Thank you.

NaomiH · 10/04/22

Can you include a screen shot of your columns? Is it like this? And would the total just show the amount that's already in Annual Estimated Savings, or is it adding it up from some other values?

Lisa Welch · 10/04/22

Hi Naomi,

I have the formula set for Idea column so it will count how many times 25%, 50%, 75% and 100% are used in confidence % column

I need to total (with a formula) each %'s dollar value. So for example 1, 25% confidence idea Annual Est Savings would be $200,000

Andrée Starå · 10/04/22

Hi @Lisa Welch

I hope you're well and safe!

Try something like this.

=SUMIFS([Annual Estimated Savings]:[Annual Estimated Savings], [Confidence %]:[Confidence %], 0.25)

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Lisa Welch · 10/04/22

Perfection!! Thank you.

Andrée Starå · 10/04/22

@Lisa Welch

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!