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

=SUM(C3:C6)

=SUM(C3,C4,C6)

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

=SUMIF(C3:C6)

Verified Answer
Correct Option - abc

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