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?
sorry, I accidently hit "best reply". I thank you for your formula, but what the other cell in the file should show is $5000 because what I want the formula to do is look at Project 1234 & further look to see if the ref# contains "ppr" or not & come up with different sums & then put it in the correct data category. So project 1234 with no "ppr" should equal $5000 & the one without "ppr" should equal $7000 & place it under 1/22/24.
rservice0320 I merely pointed out a basic flaw in your formula as I was not sure what you were trying to achieve. Still don't really understand. Sorry.
I removed the "Best reply" for you.