Sum fractional number of cells in a range

[tatoon]

Hi all,

I'm trying to sum several cells, but the problem is that the number of cells to sum can be fractional. This is, I have this table:

A	B	C	D	E	F
10	30	25	50	20	40

Now, based on a variable, I would want to sum the first 3.5 cells (from left to right). So this would mean: 10+30+25+(50*0.5)=90

Is it possible in one just formula specified a fractional range of cells?

Thanks a lot.

[shukla.ankur281190]

Row\Col	A	B	C	D	E	F
1	10	30	25	50	20	40
2
3	3.5	90
4		90

B4

Please Login or Register  to view this content.

as per your excel version 2003 it would work.

onwards 2007 can use below one also.

B4

Please Login or Register  to view this content.

[samba_ravi]

or can try (based on Ankur's example)
=IF(A3>0,SUM(A1:INDEX(A1:F1,INT(A3)),INDEX(A1:F1,INT(A3)+1)*MOD(A3,1)),"")