Help Power Excelman!

  • Thread starter Thread starter rmir1341
  • Start date Start date
R

rmir1341

DEAR EXCELMAN,


I want multiple and sum below array,for example:

A B
1 10
2 20
... ...

= (A1:A20)*(B1:B20)*(B1+B2)/2 HOW we can added (cell B1 TO B20) i
the form *(B1+B2)/2 AND then (B2+B3)/2 ......

Thanks and best regard


rmir134
 
Hi
not fully tested but try
=SUMPRODUCT(A1:A20,B1:B20,(B1:B20+B2:B21)/2)
 
You must log in or register to reply here.

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

Similar Threads

find oldest date with a condition 4
Need help with a formula 8
Need Help with a Formula 4
Excel In Excel how can I block the contenent of a cell? 0
Copy Data from One sheet to Different Sheets 1
Data Validation and drop-down list using IF, AND and what else? 8
calculate total hours/minutes from two time cells 7
Very strange behaviour of VLOOKUP in Excel 2010 4

Back
Top