Formula Help- Calculating Costs

Jessica Howell

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

Andrée Starå

Hi @Jessica Howell

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!

Jessica Howell

Here is the sheet I am working on

I will be pulling the data from here...

Jessica Howell

@Andrée Starå forgot to tag

Genevieve P.

Hi @Jessica Howell

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

Andrée Starå

@Jessica Howell

Thanks!

I saw that Genevieve answered already!

Let me know if I can help with anything else!