Weird calc (braziliam VGBL IR - 1ª part)

[Bob Phillips]

=SUMPRODUCT((($D$22/($D$22+$B$2:B2))*($A$2:A2-$A$1:A1))*$F$2:F2)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Rodrigo Ferreira]

I don't know how can explain, but I'll try to show what I want.
I have a sheet, something like this:
Lin-A-B-C-D
1- 0-0-0-0
2- 100-100-0-0
3- 201-201-0-0
4- 303,01-303,01-0-0
5- 406,0401-406,0401-0-0
6- 510,100501-510,100501-0-0
7- 615,201506-615,201506-0-0
8- 721,3535211-721,3535211-0-0
9- 828,5670563-828,5670563-0-0
10-936,8527268-936,8527268-0-0
11-1046,221254-1046,221254-0-0
12-1156,683467-1053,007184-1000-103,6762825
13-1154,574019-1154,574019-0-0
....

On G2, I have
=(((D2/(D2+B2))*(A$2-A$1))*F$2)

G3:
=(((D3/(D3+B3))*(A$2-A$1))*F$2)
+(((D3/(D3+B3))*(A$3-A$2))*F$3)

G4:
=(((D4/(D4+B4))*(A$2-A$1))*F$2)
+(((D4/(D4+B4))*(A$3-A$2))*F$3)
+(((D4/(D4+B4))*(A$4-A$3))*F$4)

G5:
=(((D5/(D5+B5))*(A$2-A$1))*F$2)
+(((D5/(D5+B5))*(A$3-A$2))*F$3)
+(((D5/(D5+B5))*(A$4-A$3))*F$4)
+(((D5/(D5+B5))*(A$5-A$4))*F$5)
....

How can extendend the function to all the lines?

Rodrigo Ferreira

 

[Rodrigo Ferreira]

Hi Bob,
The result is not the same:

1-
2- 0
3- 0
4- 0
5- 0
6- 0
7- 0
8- 0
9- 0
10-0
11-0
12-36,28669887 -->>>> This is the correct result
13-0

 

[Rodrigo Ferreira]

=SUMPRODUCT((($D1919/($D1919+$B19:B19))*($A$9:A19-$A$8:A18));$F$9:F19)

Thanks Bob!!!!!!!