Bill,

I don't understand what you mean by:

The formula does not work if there is a ( $ ) in cell M14

If either M14 is not empty or M15 does not have a number in it then it will
return an empty string which it does.

I assume that you are array entering the formula.


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"bill gras" wrote in message
...
Hi , I need some help

I have a formula as follows:

=IF(AND(M14="",ISNUMBER(M15)),SUM(OFFSET(M15,0,0,M ATCH(TRUE,M15:M38="",0)-1)),"")

The formula does not work if there is a ( $ ) in cell M14
Is there a way to chance the formula so that it will work with
the ( $ ) in cell M14

eg: M
row 14 $
row 15 25
row 16 18
row 17 17
row 18 28

any help please
--
bill gras