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

On 31 Jan., 13:41, bill gras
wrote:
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

Hi Bill,

Maybe you can change the

AND(M14="",ISNUMBER(M15)
to
AND(OR(M14="$",M14=""),ISNUMBER(M15))

Regards,
Bondi

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

Hi Bondi

Thank you very much , your amendment to my formula
works perfectly !
I'm glad you knew what I ment
once again Thank you

regards bill
--
bill gras


"Bondi" wrote:

On 31 Jan., 13:41, bill gras
wrote:
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

Hi Bill,

Maybe you can change the

AND(M14="",ISNUMBER(M15)
to
AND(OR(M14="$",M14=""),ISNUMBER(M15))

Regards,
Bondi