Forum Discussion
Excel Formula 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!
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!