Hi

Formulas can't add any rows, they only can display a value in same cell they
are in - depending on parameters.

There is hard to advice anything with so sparse information - some example
of real data and formulas along with description of sheet design would be a
great help. But in general, usually there is some column in source workbook
having non-empty value whenever there are some data in row. Then you can
easily check it in target workbook. Something like this:
=IF(SourceSheet!A2="","",YourFormula)
When you have to check several cells, then something like:
=IF(AND(SourceSheet!A2="",SourceSheet!F2=""),"",YourFormula)
or
=IF(COUNTIF(SourceSheet!A2:C2,"<>")=0,"",YourFormula)
or
=IF(COUNTIF(SourceSheet!A2:C2,"<>""")=0,"",YourFormula)
(the last formula checks for formulas returning not an empty string)
etc.

--
When sending mail, use address arvil<at>tarkon.ee
Arvi Laanemets


"Ralph Howarth" <RalphHowarth@discussions.microsoft.com> wrote in message
news:A0FADC09-9774-44F9-8137-0EDA9F6351C4@microsoft.com...
> Is it possible to have Named dynamic ranges for a worksheet included in
> formulas in another worksheet; but have the formulas automatically add
rows
> of more formulas for each row found in the source worksheet?
>
> I find that I simply have to replicate formulas a good swath of rows to
> ensure that all source data rows are calculated while using many IF
> statements to prevent empty rows of the source data worksheet from
appearing
> as zeros in the formula worksheet.
>
> I have variable rows on the source worksheet where the header row is on
row
> 3 and the formula worksheet has the header row on row 1.