Forum Discussion
Problem with a formula in Excel
I was wondering if someone could help me with the problem underneath. I typed the following formula: =SUM(I2:I1962)/SUM(I17638:I19598) =SUM(I1962:I3921)/SUM(I17638:I19598) =SUM(I3921:I5881)/SU...
This at least starts with working formulas.
= SUM( INDEX($I:$I,A5) : INDEX($I:$I,A6) )
The comma or semi-colon separator is determined by your language localisation.
I only use Names to reference data so a version that I would use looks more like
= SUM(subList)
where 'sublist' refers to
= INDEX(list, firstRow ) : INDEX(list, finalRow )
I assume you will be happier with the first version.
PeterBartholomew1 I found to a way to implement the formulas correctly, thanks for your help!