I need to take the sum of the cells in column "B" (that have the text "R") and column "C" (that have the text "Acc"). Also I need to count all cells in column "C" that have the text "Rej". But I need a formula that will allow me to take the total cell count I get from column C with "Rej" and subtract from that, the total I get from the sum of the cells of columns B and C (that meet the above criteria).
I'm sure there is an easier way to explain that, so I apologize if it sounds confusing.
It has also happened to me before: spent hours of work and wasted hours of sleep trying to find a solution; then decided to ask for help in a forum. When I saw the answer, I could not believe I had not been able to figure that out myself. :-)
If you can mark my answer as the best answer, it would be great! Enjoy your weekend and have lots of fun with Excel!
Best Response confirmed by
WillJa67 (New Contributor)