Formula to not calculate a status referenced with N

Bev

New member
Joined
Jun 12, 2014
Messages
1
Reaction score
0
Points
0
I am working on a spreadsheet and am entering formulas to calculate the percentage based on the status of the items. I have items in the status column listed in a drop down list as G, Y, R or N. Here is what I have written currently: =GreenScore*COUNTIF(Status_Sales0,"g"), another =YellowScore*COUNTIF(Status_Sales0,"y"), another =RedScore*COUNTIF(Status_Sales0,"r") which are working fine. But I need to add another formula for No Score, if the status is N I want a formula to just ignore it and not calculate it as it is not applicable for certain processes and should not be included in the calculation. Any suggestions would be greatly appreciated. Thanks.
 
I don't know what you mean by "if status is N I want the formula to just ignore it and not calculate". Can you elaborate?
 
Back
Top