A
annysjunkmail
I am trying total x no of cols based on the following conditions.
Cols to count: =WebsiteScores!J1
Starting col: =WebsiteScores!O3
End col: =WebsiteScores!O4
Using the following grid as an example on sheet 1,
A B C D E F G
1 1 2 3 5 6 7
J1=3
O3=1
04=4
which means produce total of 3 cols (J1) starting at colA and end at
ColD. Total is therefore 7.
I have the following formula on which totals the cols selected by J1
but does not account for the variable starting and ending cols.
=SUM(OFFSET($L2,0,1,1,WebsiteScores!$J$1))
Can someone help?
Thanks
Tony
Cols to count: =WebsiteScores!J1
Starting col: =WebsiteScores!O3
End col: =WebsiteScores!O4
Using the following grid as an example on sheet 1,
A B C D E F G
1 1 2 3 5 6 7
J1=3
O3=1
04=4
which means produce total of 3 cols (J1) starting at colA and end at
ColD. Total is therefore 7.
I have the following formula on which totals the cols selected by J1
but does not account for the variable starting and ending cols.
=SUM(OFFSET($L2,0,1,1,WebsiteScores!$J$1))
Can someone help?
Thanks
Tony