Sumproduct of every third row where cells to be multiplied are offset in two columns

**bill@williamcha** · 05-08-2015, 05:12 PM

I have a large table that I simplify below. This reprsents 3 wigits labled 1,2, and 3 in column A. Each widget has 3 rows of data associated. I want the sumproduct of B1*E3+B4*E6+B7*E9 or 2*10+10*5+1*2=72

Simplified.jpg Simplified.jpg

If I write equation for the sumproduct as above for 100 widgits, it is easy to make a mistake. Is there a formula that adds offset datab using SUMPRODUCT?

**Richard Buttrey** · 05-08-2015, 05:24 PM

Hi,

Do you mean that you want a formula in E10 that you can copy to, E20, E30, E40 etc., or do you want a single formula grand total of column E that evaluates each pair of offset values from B & E?

Sumproduct of every third row where cells to be multiplied are offset in two columns

LinkBack

Thread Tools

Rate This Thread

Display

Sumproduct of every third row where cells to be multiplied are offset in two columns

Re: Sumproduct of every third row where cells to be multiplied are offset in two columns

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] SUM cells with same content and multiplied by quantity of each

vba to check if answer from 2 cells with =int(rand()*number) multiplied together is equal

[SOLVED] Result of Sumproduct multiplied

Trying to sum 4 cells where 1 is multiplied without exceeding a value.

[SOLVED] Simple Sumproduct of 2 Columns, with some blank cells in range

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions