Google Sheets - Is this doable?

[lifted731]

Hey there!

I'm looking for some help creating a formula. I have linked a CSV of the sheet I'm working on, below.

The goal is to quantify how many errors occur during inventory transfers and then modified by a scale of how impactful that error is. I'm open to other ideas on how to get to this goal but here is what i was thinking.

I hope that makes sense, and again, if there's any other ways to achieve the goal I'm all ears.

I think the important things for me are to show how often these things happen and assign a value of how much the errors negatively effect efficiency. The scale i gave it currently was just a 1 or a 2 with 2 being a heavier impact.

Thanks!

TO Success Rate - September.csv

 

[WarPigl3t]

=SUMIFS($A$2:$A$6, C$1, C$11, $C$2:$C$6, TRUE) + SUMIFS($A$2:$A$6, C$1, C$11, $D$2:$D$6) + SUMIFS($A$2:$A$6, C$1, C$11, $E$2:$E$6) + SUMIFS($A$2:$A$6, C$1, C$11, $F$2:$F$6) + SUMIFS($A$2:$A$6, C$1, C$11, $G$2:$G$6) + SUMIFS($A$2:$A$6, C$1, C$11, $H$2:$H$6)

 

[lifted731]

Sorry for the delayed response and thank you for that. I'm a super noob so i guessed that this formula would go into cell C13 to the right of my note under transfer total impact. However, im getting the following error. "Array arguments to SUMIFS are of different size." I tried playing around with the formula making assumptions on how its working but got no where. Any chance i can get some context and diagnostics assistance?

Links to spreadsheet:
XLSX File
CSV File

 

[p_s]

Would something like this work for you? For lifted731

I didn't have access to your file so I made my own, but I didn't type our your error descriptions, sorry.

 

[p_s]

You could also have the total impact color graded from most impact to least impact by adding conditional formatting.

 

[lifted731]

I like this a lot, thank you @p_s

Although how can i get "#of instances" to count how many checkmarks under a given date? rather than how many times the date shows up.

 

[p_s]

I like this a lot, thank you @p_s

Although how can i get "#of instances" to count how many checkmarks under a given date? rather than how many times the date shows up.

updated,

 

[lifted731]

updated,

Thanks a ton!!!