I am going to try to explain this as best as I can to get as much assistance from this forum as possible. I am modifying a report for my Manager because the data we were logging/tracking in 1&2 quarter has changed. We were using COUNTIFS because we only needed to count the data, now we need a sum of a particular range and specific criteria.
=COUNTIFS('Raw Data'!P:P,"<>In-progress",'Raw Data'!M:M,"Triggers",'Raw Data'!G:G,"BB Mass")
P:P is the final disposition (Done, Follow-up etc)
M:M is the type of review (Trigger, New product etc)
G:G is the business segment who sent us the request (BB Mass, Large Corp etc)
New tracking - Please note many of the columns (from above) may have changed. Going forward we're tracking the # of errors we correct and we're assigning a level of severity of each (based on the amount of time it takes to correct them). Column P:P (from above) has been removed.
I am trying to get a sum of Column N:N (actual # of errors inputted here), for only "Triggers" (column M:M) business segment BB Mass (column G:G) THE ISSUE IS because there are three levels of severity we've broken them out in three different columns - column N:N is dedicated solely for Regulatory (error level). There is no text (ie regulatory) in column N:N ONLY the # of regulatory errors we had to fix.
I am in need of a formula that will give me a sum of all Regulatory errors for Triggers and BB Mass ONLY.
I gave it a try but this is not working:
=SUMIFS('Raw Data'!N:N,'Raw Data'!G:G,"BB Mass",'Raw Data'!M:M,"Triggers",'Raw Data'!N:N,">=1")
I am pretty sure my issue is the <=1 but I'll leave that up to you EXPERTS to correct. Thank you!
I tried to share as much info as possible!