Based on the values in Cell A51: A55, what formula can you copy and paste in to Cells B51: B55 to return the values shown?

 

Transcribed Image Text:

51 Red 52 Red 53 Red 54 Blue 55 Red Image not displaying? A =IFNA(A51="Red","Yes","No") =COUNTIF(A51="Red","Yes","No") =SUMIF(A51="Red","Yes","No") =IF(A51="Red","Yes","No") Yes Yes Yes No Yes =SHOWIF(A51="Red","Yes","No") B Q 51 Red 52 Red 53 Red 54 Blue 55 Red Image not displaying? A =IFNA(A51="Red","Yes","No") =COUNTIF(A51="Red","Yes","No") =SUMIF(A51="Red","Yes","No") =IF(A51="Red","Yes","No") Yes Yes Yes No Yes =SHOWIF(A51="Red","Yes","No") B Q 51 Red 52 Red 53 Red 54 Blue 55 Red Image not displaying? A =IFNA(A51="Red","Yes","No") =COUNTIF(A51="Red","Yes","No") =SUMIF(A51="Red","Yes","No") =IF(A51="Red","Yes","No") Yes Yes Yes No Yes =SHOWIF(A51="Red","Yes","No") B Q 51 Red 52 Red 53 Red 54 Blue 55 Red Image not displaying? A =IFNA(A51="Red","Yes","No") =COUNTIF(A51="Red","Yes","No") =SUMIF(A51="Red","Yes","No") =IF(A51="Red","Yes","No") Yes Yes Yes No Yes =SHOWIF(A51="Red","Yes","No") B Q

Answer rating: 100% (QA)

In this case the COUNTIF function in Google Sheets or Excel can be ... View the full answer