Hi...

My query is a simple one but I am totally stuck with this

I am a beginner with excel formulas hence some help needed.

Q) If the value in the required cell is "Blank" then it should return the value Blank to me and if it has anything written in that cell then it should follow my further COUNTIF formula.

As easy as this one!!!

I am not able to make my sheet recognize if that cell is empty or has any kind of data in it.

Imp thing is.. that I am typing the formula in one worksheet and it need to pick the data from another excel Worksheet. Its like.. M creating a dashboard for all my excel sheets so that I can check in One Go where the count differs and then update those files accordingly.

Thus trying to link the 2 files.

Any help will be Appreciated.

Thanks
Lin