help with formula

[Guest]

Hi , I need some help

I have a formula as follows:

=IF(AND(M14="",ISNUMBER(M15)),SUM(OFFSET(M15,0,0,MATCH(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

 

[Bondi]

Hi , I need some help

I have a formula as follows:

=IF(AND(M14="",ISNUMBER(M15)),SUM(OFFSET(M15,0,0,MATCH(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

Hi Bill,

Maybe you can change the

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

Regards,
Bondi

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Guest]

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