Hi,

I have a spreadsheet where I want to determine the percentage of quantity either from produced water or ground water as below.
I do not know how to apply the "sumif" formula because the produced water and ground water columns will have text in them from multiple locations.
I am sure there is a easy way around this.

Untitled.png

Thanks.