Using COUNTIFS on 3 different columns and then need to SUM a 4th column... Please Help

[bjh894]

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")

 

[Canapone]

Hi,

maybe

=SUMIFS(Cases!AB2:AB552,Cases!B2:B552,1,Cases!G2:G552,"c*",Cases!X2:X552,"No",Cases!AB2:AB552,">0")

Regards

 

[bjh894]

You Sir or Madam... are the Shiznit ! That worked. I VERY MUCH appreciate it and if you make it to LA, I owe you lunch.

 

[Canapone]

Hi, thanks for the feedback, very kind of of you.

Regards from Firenze (Florence)