Based on the values in Cells A$51$:A$55,$ what formula can you copy and paste into Cells $B51$:$B55$ to return the values shown?

$\backslash$table$[[,,$A$],[51,$Red,Yes$],[52,$Red,Yes$],[53,$Red,Yes$],[54,$Blue,No$],[55,$Red,Yes$]]$

Image not displaying?

$=$IFNA$($A$51=$"Red","Yes","No$")$

$=$SHOWIF$($A$51=$"Red","Yes","No$")$

$=$COUNTIF$($A$51=$"Red","Yes","No$")$

$=$SUMIF$($A$51=$"Red","Yes","No$")$