CountIF with single non condition

[PavithraSubba]

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

 

[PavithraSubba]

Thank you All!!!!

Finally i got a result..

=COUNTIF(ReportfromMSSP!$I$2:INDEX(ReportfromMSSP!I:I,MATCH(REPT("z",255),ReportfromMSSP!I:I)),"<>Cancelled")
works welll...Thanks for your support

 

[mfexcel]

You are welcome. Glad it helps.

Thank you All!!!!

Finally i got a result..

=COUNTIF(ReportfromMSSP!$I$2:INDEX(ReportfromMSSP!I:I,MATCH(REPT("z",255),ReportfromMSSP!I:I)),"<>Cancelled")
works welll...Thanks for your support