"RANKIFS" Formula Using COUNTIFS - Ignore fields that contain zeroes

[fsuguy92]

Hey guys, I am trying to use a rank formula that has an "if" clause in it. Essentially, I have a list of text in column S and values in column Y and ranking the values based on the text. Here is my current formula:

=COUNTIFS($S$13:$S$1068,S13,$Y$13:$Y$1068,">"&Y13)+1

What I want to do is exclude items where column U and column W = 0

Thanks for the help!

 

[C Moore]

Did you look at this? Rank based on Multiple criteria (Like a RankIFS)