A key point to remember about array formulas is that they must be
committed/terminated with [Ctrl]+[Shift]+[Enter], EVEN AFTER EDITING. Just
using the [Enter] key will not commit them as an array formula.

"Lynda" wrote:

I have taken over a workbook from a former work colleague. The workbook has a
spreadsheet with array formulas in it. I have never used array formulas
before so have needed to do a crash course of trial and error. When I need to
do something I am unfamiliar with I always make a copy first then I work on
the copy. I needed to update the sheet by removing rows. When I have put the
formulas back in the bottom row comes up with #N/A. I thought perhaps it was
because there were no numbers in that row, but on the original sheet there
were no numbers either and the formula was fine. Can someone please help me
and also tell where I might be able to learn more about how these formulas
work.

Cheers
Lynda