Forum Discussion
Solved
combine sum logic if a cell contains certain text & exclude adding if has certain text
I have certain projects with various reference #'s. I would like to sum the projects that contain a specific identifier & then sum the same project that excludes that identifier. I have attached a ...
Does the attached version return the intended result?
in my file, cell E11 should be equal to $5000 as what I want to do is sum project 1234 without a Ref# containing "ppr" as well as sum project 1234 with a ref# of "PPR" & then place it under the correct date. again...apologies for reposting the question...don't know how to remove the reposting
Does the attached version return the intended result?
- Oliver,
This is exactly what I needed! Thank you so much!