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.