I have written this formula below. I do not know the correct part of this formula that will add the numbers I have in Column AB2:AB552 (bold below). As it is, this formula is counting the number of cells in that range that has numbers in it, but I need it to total those numbers as my final result. Any help would be great.
=COUNTIFS(Cases!B2:B552,"1",Cases!G2:G552,"c*",Cases!X2:X552,"No",Cases!AB2:AB552,">0")
=COUNTIFS(Cases!B2:B552,"1",Cases!G2:G552,"c*",Cases!X2:X552,"No",Cases!AB2:AB552,">0")