$ every 6th row * # every 6th row base on a criteria every 6th row

[ozbeachbum]

Hi all,
Any help with the following would be greatly appreciated.

$ every 6th row * # every 6th row base on a criteria every 6th row
D70 is the first cell containing criteria (Criteria is >0) Last cell D328
Q73 is the first cell containing $ Last cell Q331
Q72 is the first cell containing # Last cell Q330

I need each $ * # if >0 and the results add together.
EG:
D70 >0 Q73 $10 * Q72 5 = $50
D76 >0 Q79 $15 * Q78 2 = $30
D82 <0 Q85 $12 * Q84 2 = $00
The result would be $80

The cell with the result in it is in one workbook and the data cells in another.
The cells between the cells with the required data, may contain; blanks; zeros; formulae or other $ and #

Cheers,
Dave.

 

[Peter_SSs]

Glad it all worked out! Thanks for the confirmation

BTW, not sure why I used such an awkward construct to get the SEQUENCE values. This would have been simpler.

=LET(s,SEQUENCE(ROWS(D70:D328)/6,,,6),SUM((INDEX(D70:D328,s)>0)*INDEX(Q70:Q328,s+2)*INDEX(Q70:Q328,s+3)))