Hi All,

I have searched and searched but, cannot find a logical answer to my problem!

I am trying to enter a SUMIF formula into cell C4 with the criteria being in cell B4; cell C4 does not need to be very big at all because, I am expecting only a single digit to return after the SUMIF formula.

However, on this and many other occasions I am getting frustrated by the cell's formula bar (not the formula bar at the top) as, it expands and overlaps adjacent cells when I enter in large formulas.

Is there away in which to stop this from happening? I really don't know why it needs to happen at all because, there is a perfectly good formula bar at the top of the page in which to see what you are entering. (It is useful on occasion I know, I am just frustrated about this issue)

Preferably, I would like the cell to look like =SUM...... and just show what will fit into my small cell, with the rest of the formula being followed and entered in the top formula bar.

I have just Signed up to this site in the last few moments and would appreciate greatly if anyone can help me.