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

Telegram

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Qtr No. 213, New Town Yehlanka Indore 454775

admin@prepflix.in

Updated on Thu, 11 Dec 2025