Apr 24 2019 01:54 PM
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.
Apr 24 2019 08:41 PM
Hi, there! I am not sure if I get your explanation.
I assumed that when you say "sum of the cells" you meant "count of rows" where the criteria were met.
If that's the case, please try the formula
=COUNTIFS(B:B,"R",C:C,"Acc")-COUNTIFS(C:C,"Rej")
If that's not the case, please let me know.
Please see the file attached with the formulas and an example.
Apr 25 2019 04:19 AM
Celia, that was almost perfect. It was just backwards, so I switched and it worked perfectly.
=COUNTIFS(C6:C1836,"Rej")-COUNTIFS(B6:B1836,"R",C6:C1836,"Acc")
Not sure why I could not figure that out, but it was killing my brain..lol.
Thank you so much for your help.
Apr 26 2019 08:58 AM
SolutionYou're welcome! My pleasure to help.
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!
Apr 26 2019 08:58 AM
SolutionYou're welcome! My pleasure to help.
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!