Sum if in value in a comma delimited list in one cell

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

I have the output for project listing of acres treated.
In one column, it has a listing partners involved in
treatment. Is there a way to only sum acres treated if
they include a certain partner?

For Example:
A B
BIA, BLM, State, County, Nonprofit 200
County, Nonprofit 10
BIA, BLM 70
BLM 24
BLM, State, County, Nonprofit 145
State, County 45

I want to sum acres for only cells with county
partnerships. How would I do that?
The result I am after is (200+10+145+45)=400

It also would be interesting if I could do for a
combination like BIA and BLM.
The result would be (200+70) = 270
 
Back
Top