Hi-

I am trying to use a sumproduct, but it returns a zero. Would this have anything to do with the fact that the numbers in the cells in column S are a formula? If so, any suggestions to fix?

Thanks

=SUMPRODUCT((S9:S31)*(M9:M31="PH"))