• 546K Members
• 2,325 Online
• 652K Conversations
SOLVED

Highlighted
New Contributor

# 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.

3 Replies
Highlighted

# Re: Excel Formula HELP

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.

Highlighted

# Re: Excel Formula HELP

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.

Highlighted
Solution

# Re: 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!

Related Conversations
Mattlewis in Excel on
2 Replies
Help with excel
Alexvez01098 in Excel on
10 Replies
Rotate data from single cell to vertical listings
WEI_Bob in Excel on
2 Replies
2 Seniority Lists
Aminam20 in Excel on
9 Replies
Conditional formatting with wildcard
Rajeev_Raghavan in Excel on
2 Replies