Calculate a percentage when row cell meets criteria..

Hello,

Name's Dave, new to the forum. I'm trying to figure out how to calculate results in a cell, per row, when it meets certain criteria. My table contains a series of letters and numbers. Column 1 has letters, A/Q/C - only one letter per row... A, Q, or C. Columns 2/3 have numbers, and column 4 is the calculation. I'm wanting to calculate the percentage, per row, between columns 2/3 IF column 1 has a "C" present in the row. If it doesn't meet this criteria then display a message. Is this possible?

Thanks..

Guess that would be helpful wouldn't it?

Originally Posted by Naveed Raza

Check it out attached file and let me know is it what your looking for

Excellent! Exactly what I'm looking for ~ Thank you Naveed!! Never thought to use the 'if' statement. Have a great weekend ..

Originally Posted by Naveed Raza

Glad i could help you

1. If the suggestion helps you, then Click * to Add Reputation and give your comments over there
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

Already done, meaning reputation and will mark thread solved. Thanks again!!