Does a countif(s) formula need a column?

[Pezgordo]

I have a worksheet that has a row of averages (row 6) and below this row (row 8) I place current performance. Is there anyway I can create a formula that will place a "U" or an "O" (or a 1 or a 2) in row 10 based on whether the current performance is U(nder) or O(ver) the averages w/o there being an O/U column in the worksheet?

For example, B6 = 18.26, B8 = 15. Can I create a countifs formula at cell B10 that will show a "U" (based on 15 being UNDER 18.26)?

Thank you,

Tim

 

[Scott Huish]

Why COUNTIF?

Based on your description, in B10:

You didn't say what to do if they are equal, so I am leaving that returning a blank:

=IF(B6=B8,"",IF(B6>B8,"U","O"))<B8,"U","O"))< p>

 

[vidplaylist]

<TABLE style="WIDTH: 305pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=406 border=0><COLGROUP><COL style="WIDTH: 209pt; mso-width-source: userset; mso-width-alt: 5083" width=278><COL style="WIDTH: 96pt" width=128><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 209pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=278 height=20>Average</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 96pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=128>18.26</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Current Performance</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">15</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Decision Criteria</TD><TD class=xl63 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">=IF(B$8>B6,"O","U")</TD></TR></TBODY></TABLE>

You can also add in formula if B8=B6 then empty like "Hotpepper" moderator did.

If you want to count the number of "U" and "O" then you have to put another formula in addition to this if formula

 

[Pezgordo]

Thanks guys. This is exactly what I was looking to do.