Johnny C
Well-known Member
- Joined
- Nov 7, 2006
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
I have a set of columns with data in that relates to rows above. So, can I multiply a set of cells in a row by their transpose in a column?
This is what I'm trying to achieve (in cell C12) :-
=SUMPRODUCT(OFFSET($AD12,0,0,ROW()-2,1),C$2:C11)
10 cells across by 10 cells down.
I would prefer not to use array formulae if I can, I'll do a VBA function if there's no non-CSE way
Cheers
This is what I'm trying to achieve (in cell C12) :-
=SUMPRODUCT(OFFSET($AD12,0,0,ROW()-2,1),C$2:C11)
10 cells across by 10 cells down.
I would prefer not to use array formulae if I can, I'll do a VBA function if there's no non-CSE way
Cheers