Formula Help- Calculating Costs

Options

Hello,

So i have this formula: =COUNTIFS({Environmental Incident Tracking Range 3}, "1", {Environmental Incident Tracking Range 7}, =(2020), {Environmental Incident Tracking Range 5}, "R507", {Environmental Incident Tracking Range 1}, "Leak / Fuite")

But i need it to match this criteria, but calculate the cost accumulated from R507 Leaks.

Cost is in Range 8, called "cost of refrigerant"

TIA

• ✭✭✭✭✭✭
Options

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

Here is the sheet I am working on

I will be pulling the data from here...

• Options

@Andrée Starå forgot to tag

• Employee
Options

What is the issue you are coming across? Do you mean that you need to change the COUNT formula to be a SUM formula, instead?

SUMIFS is a great function which is built essentially the same as that COUNTIFS, the only difference being that you reference the range you want to SUM as the very first range, then go into all the criteria.

Try This:

=SUMIFS({Environmental Incident Tracking Range 8}, {Environmental Incident Tracking Range 3}, "1", {Environmental Incident Tracking Range 7}, =(2020), {Environmental Incident Tracking Range 5}, "R507", {Environmental Incident Tracking Range 1}, "Leak / Fuite")

Keep in mind that Range 8 will need to store numerical data for the formula to be able to calculate. Let me know if this works for you!

Cheers,

Genevieve

Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now

• ✭✭✭✭✭✭
Options

Thanks!

Let me know if I can help with anything else!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!