Replies

And also useful are the shortcuts:

CTRL + D (which fills down however many cells are selected)

CTRL + R (which fills to the right however many cells are selected)

And also useful are the shortcuts:

CTRL + D (which fills down however many cells are selected)

CTRL + R (which fills to the right however many cells are selected)

I had this problem a couple of years ago. It seemed that the only “solution” was to restart the computer. Not acceptable solution, but it usually avoided the problem for a few months. The mouse (not a wheel mouse) was the problem, and it never affected other Office programs. When I changed to a wheel mouse, I have never had the problem.

I had this problem a couple of years ago. It seemed that the only “solution” was to restart the computer. Not acceptable solution, but it usually avoided the problem for a few months. The mouse (not a wheel mouse) was the problem, and it never affected other Office programs. When I changed to a wheel mouse, I have never had the problem.

[indent]

---

I’ve tried the “fit to” and adjusting the scaling %

---

[/indent]

The “fit to” and “adjust scaling” will often conflict. Also, it depends on what your number of columns is. If you have many columns then “fit to” will adjust for the columns, not the rows.

[indent]

---

I’ve tried the “fit to” and adjusting the scaling %

---

[/indent]

The “fit to” and “adjust scaling” will often conflict. Also, it depends on what your number of columns is. If you have many columns then “fit to” will adjust for the columns, not the rows.

The SUMRPODUCT will do that. (I used A1 for Cell 1 and B1 for Cell 2).

The SUMRPODUCT will do that. (I used A1 for Cell 1 and B1 for Cell 2).

Try SUMPRODUCT((Range1>A1)*(Range1<B1)*(Range2))

Try SUMPRODUCT((Range1>A1)*(Range1<B1)*(Range2))

Thanks, Steve. That’s why I enjoy and try to learn as I go.

Thanks, Steve. That’s why I enjoy and try to learn as I go.

Thanks, that makes sense.

That must be why he offers this one for case sensitive partial cell contents match:

=SUM(IF(LEN(data)-LEN(SUBSTITUTE(data,text,””))>0,1)) (array entered)

Thanks, that makes sense.

That must be why he offers this one for case sensitive partial cell contents match:

=SUM(IF(LEN(data)-LEN(SUBSTITUTE(data,text,””))>0,1)) (array entered)

As long as that Named range is one cell.