From: Michelle Embleton Michelle on 7 Apr 2010 04:14 hello, I wonder if anyone can help with the following, I have a colleague who would like to sum and multiply at the same time in a large spreadsheet. He can do this if he types out the whole formula as =sum(a3*a5, b3*b5, etc) but this is extremely laborious for him. If he tries to use =sum(a3*a5:z3*z5) it converts his formula to =sum(a5*a5:z5*z5) and gives him #value as an answer. Is there any way round this problem? From: Roger Govier on 7 Apr 2010 04:25 Hi Michelle Try =SUMPRODUCT(A3:Z3*A5:Z5) -- Regards Roger Govier Michelle Embleton wrote:> hello, I wonder if anyone can help with the following, I have a colleague > who > would like to sum and multiply at the same time in a large spreadsheet. He > can do this if he types out the whole formula as =sum(a3*a5, b3*b5, etc) but > this is extremely laborious for him. If he tries to use =sum(a3*a5:z3*z5) it > converts his formula to =sum(a5*a5:z5*z5) and gives him #value as an answer. > Is there any way round this problem? > > From: מיכאל (מיקי) אבידן on 7 Apr 2010 04:28 Let him try: SUMPRODUCT Micky "Michelle Embleton" wrote: > hello, I wonder if anyone can help with the following, I have a colleague > who > would like to sum and multiply at the same time in a large spreadsheet. He > can do this if he types out the whole formula as =sum(a3*a5, b3*b5, etc) but > this is extremely laborious for him. If he tries to use =sum(a3*a5:z3*z5) it > converts his formula to =sum(a5*a5:z5*z5) and gives him #value as an answer. > Is there any way round this problem? > > From: מיכאל (מיקי) אבידן on 7 Apr 2010 04:38 ....and only after(!) learning the use of SUMPRODUCT - he may use: =SUMPRODUCT(A3:Z3,A5:Z5) Micky "מיכאל (מיקי) אבידן" wrote: > Let him try: SUMPRODUCT > Micky > > > "Michelle Embleton" wrote: > > > hello, I wonder if anyone can help with the following, I have a colleague > > who > > would like to sum and multiply at the same time in a large spreadsheet. He > > can do this if he types out the whole formula as =sum(a3*a5, b3*b5, etc) but > > this is extremely laborious for him. If he tries to use =sum(a3*a5:z3*z5) it > > converts his formula to =sum(a5*a5:z5*z5) and gives him #value as an answer. > > Is there any way round this problem? > > > > From: Bob Phillips on 7 Apr 2010 05:12 There is no need for the * operator Roger, there are no conditions. =SUMPRODUCT(A3:Z3,A5:Z5) works just fine -- HTH Bob "Roger Govier" wrote in message news:4BBC418C.5050808(a)technology4nospamu.co.uk...> Hi Michelle > > Try > =SUMPRODUCT(A3:Z3*A5:Z5) > -- > Regards > Roger Govier > > Michelle Embleton wrote: >> hello, I wonder if anyone can help with the following, I have a >> colleague who would like to sum and multiply at the same time in a large >> spreadsheet. He can do this if he types out the whole formula as >> =sum(a3*a5, b3*b5, etc) but this is extremely laborious for him. If he >> tries to use =sum(a3*a5:z3*z5) it converts his formula to >> =sum(a5*a5:z5*z5) and gives him #value as an answer. Is there any way >> round this problem? >>  |  Next  |  Last