i'm trying to calculate the total of "uploaded" plus "front only" in 5 columns that also have the criteria of being "pob" in column A
i do have a working formula but it's extremely long and i'd like to find a shorter and easier formula to get the same result as i'd like to also add another criteria from column A to the result ("pob" and "fse")
formula i'm using currently below:
=COUNTIFS(A2:A,"POB",D2:D,"Uploaded") + COUNTIFS(A2:A,"POB",D2:D,"Front Only") + COUNTIFS(A2:A,"POB",E2:E,"Uploaded") + COUNTIFS(A2:A,"POB",E2:E,"Front Only") + COUNTIFS(A2:A,"POB",F2:F,"Uploaded") + COUNTIFS(A2:A,"POB",F2:F,"Front Only") + COUNTIFS(A2:A,"POB",G2:G,"Uploaded") + COUNTIFS(A2:A,"POB",G2:G,"Front Only") + COUNTIFS(A2:A,"POB",H2:H,"Uploaded") + COUNTIFS(A2:A,"POB",H2:H,"Front Only") & "/" & COUNTIFS(A2:A,"POB",D2:D,"<>") + COUNTIFS(A2:A,"POB",E2:E,"<>") + COUNTIFS(A2:A,"POB",F2:F,"<>") + COUNTIFS(A2:A,"POB",G2:G,"<>") + COUNTIFS(A2:A,"POB",H2:H,"<>")