Forum Discussion
Excel Formula HELP
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.
You'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!
3 Replies
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.
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.
You'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!
