Excel: CountIF with single non condition

I'm trying to count all the values except one value in a column.Column having more than 5 different types of values,except one vlaues i wanna count remaining.The problem is when i use <> it is counting entire excel cells in a column =COUNTIFS(ReportfromMSSP!I:I,"<>Cancelled").it is returning 1048550.but i'm having only 205 column

This question generated 32 answers. To proceed to the answers, click here.

This thread is current as of March 25, 2014.

For more resources for Microsoft Excel