Sumproduct copying blanks or how to insert zero into blanks

[Guest]

When requesting a report on my database it saves to excel leaving blanks.
Using sumproduct I can not copy my formula down the column because it seems
that the blank spaces copy the previous adjacent answer until a non blank
result comes up in the column. How can I fix this. I tried copy/paste with
skip blank but that did not work.

 

[Guest]

I think you'll need to give some more details.

What are you actually trying to do?
Copy non-blank records to another area?
Something else?

Can you post:

Some sample data from the database
The formula you're using that's not working

***********
Regards,
Ron

XL2002, WinXP

 

[Peo Sjoblom]

If you want to remove blank cells, select the range, press F5, click special
and select blanks, press Ctrl + - (Ctrl key and minus key) or edit>delete,
then select entire row or select shift cells up depending on if there are
rows where the blanks are that have values in other columns

 

[Guest]

Here is the formula I am trying to copy paste down the column. DATA07-05 has
bank spaces on some lines due to nothing to report. There are numerous
blanks throughout the report. I will uses this formula for several columns
but I change the column search criteria. I normally don't have a problem
when the report is populated with a number. I hope this better explains this.

=SUMPRODUCT(('DATA07-05'!$A$7:$A$446=GA!$A4)*('DATA07-05'!$C$7:$C$446=GA!$C$4)*('DATA07-05'!$D$7:$D$446=GA!$A$1)*('DATA07-05'!$J$7:$J$446))

 

[Guest]

Rows that have blank cells have data in other cells in different columns. I
can not elininate or move the data. Will what you describe still work?