hello guys....please help
i have :

in A1... "1"
in A2...."2"
in A3...."x"
in A4..."yard"
i want a formula wich says....give me the sum of A1 to A4 even if there is a
letter like "x" or a word like "yard".....
i would like to have the result "3"
how to do that ? sumproduct maybe ??

PLEASE HELP ME

You're thinking too hard. SUM automatically ignores text.
=SUM(A1:A4)

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"pierre" wrote:

hello guys....please help
i have :

in A1... "1"
in A2...."2"
in A3...."x"
in A4..."yard"
i want a formula wich says....give me the sum of A1 to A4 even if there is a
letter like "x" or a word like "yard".....
i would like to have the result "3"
how to do that ? sumproduct maybe ??

PLEASE HELP ME

Luke M;238107 Wrote:
You're thinking too hard. SUM automatically ignores text.
=SUM(A1:A4)

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"pierre" wrote:

hello guys....please help
i have :

in A1... "1"
in A2...."2"
in A3...."x"
in A4..."yard"
i want a formula wich says....give me the sum of A1 to A4 even if
there is a
letter like "x" or a word like "yard".....
i would like to have the result "3"
how to do that ? sumproduct maybe ??

PLEASE HELP ME

SUM ignores text the same way many users ignore XL's Help :)


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=66454