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