Sum and multiply at the same time?

  • Thread starter Michelle Embleton
  • Start date
M

Michelle Embleton

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?
 
×

מיכ×ל (מיקי) ×בידן

Let him try: SUMPRODUCT
Micky
 
×

מיכ×ל (מיקי) ×בידן

....and only after(!) learning the use of SUMPRODUCT - he may use:
=SUMPRODUCT(A3:Z3,A5:Z5)
Micky
 
B

Bob Phillips

There is no need for the * operator Roger, there are no conditions.

=SUMPRODUCT(A3:Z3,A5:Z5)

works just fine
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top