SUMPRODUCT won't work when copying empty cells as values

[FlossyGlamourous]

Excel stopped working the way it had always did without any interference and I would like to fix the problem.

The procedure is as follows. I produce a sheet with formulae in A10:A15, A20:A25 and so on up to A100:A105, B10:B15, B20:B25 and so on up to B100:B105. Before sending it to further recipients, I copy it as values.

Up to now, the resulting sheet allowed to jump over the blocks using CTRL + arrows and using SUMPRODUCT of A and B.

Now, CTRL + arrows jumps from row 10 to row 105 without stopping in the interim and SUMPRODUCT yields errors. I have also discovered that when I double-click a presumably empty cell, say, C4 in this case, copy the void using CTRL + C and search for it using CTRL + F and replace by anything non-void like "sdvfgfr", the entire list is being filled by this "sdvfgfr". Then I reverse it - search for "sdvfgfr" and replace by nothing, CTRL + arrows and SUMPRODUCT start working again.

I will really appreciate if you help handle this strange problem.

[Richard Buttrey]

Hi and welcome to the forum.

Methinks it's time for you to upload the actual workbook, or at least a representative sample. It's always easier to assist if we can see the apparent problem in context.

[FlossyGlamourous]

I tried to use the Manage Attachments option, but it would not allow me to upload anything. May I share the files somewhere else or (if I do not cope with it) does anybody have at least initial ideas what the problem might be?

[Pepe Le Mokko]

Click on GO ADVANCED ( edit original post ) and use the paperclip icon to open the upload window.

View Pic

[FlossyGlamourous]

I can do it and I get as far as the Browse button, but after pressing Upload virtually nothing happens.