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!
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!