SOLVED: What will be formula in the formula bar which will calculate the total number of ...

What will be formula in the formula bar which will calculate the total number of products sold omitting the products which is NOT SOLD for the given below image?

=COUNTIF(C3:C6,"<>Not Sold")

=COUNTIF(C3:C6,Not Sold)

=COUNTIF(C3:C6,"<>"&C5)

=COUNT(C3:C6)

Verified Answer

Correct Option - acd

To get all Self Assessment for Exploring Excel Exam questions Join Telegram Group https://rebrand.ly/lex-telegram-236dee