Algebraic calculation of summation formula of equal ratio sequence Formula s = A1 (1-Q ^ n) / 1-Q Suppose the sequence is 1,4,8,32128 A1 = 1, common ratio q = 4, isn't that a negative number?

Algebraic calculation of summation formula of equal ratio sequence Formula s = A1 (1-Q ^ n) / 1-Q Suppose the sequence is 1,4,8,32128 A1 = 1, common ratio q = 4, isn't that a negative number?

Please... 1, 4, 8, 32128 are not equal ratio series
4 / 1 = 4, 8 / 4 = 2
But even so, it's not negative
1-Q ^ n < 0, 1-Q < 0, negative offset or positive

How to set the formula of horizontal multi condition summation
A B C E D
Customer name variety 1 variety 2 variety 3 variety 4
Li Da 10 90 20 30
Sophomore 11 108 50 40
Zhang San 10 50 60 80
In Table 2, the formula is given: (for example, Li Da, the sum of variety 1 + variety 2; the sum of variety 3 + variety 4)
Customer name variety 1 + 2 variety 3 + 4
Li Da 100 50
Maybe I didn't make it clear. Here's a supplement:
Customer name variety 1 + 2 variety 3 + 4
Li Da 100 50 (the amount obtained here, how to set the formula, when the name of variety 1 and variety 2 above is satisfied, the amount calculated is 100). When the name of variety 3 or variety 4 is also satisfied, 50 yuan is obtained

Table 2B2 cell input formula (variety 1 + 2 formula) = SUMIF (Sheet1! A: A, A2, Sheet1! B: b) + SUMIF (Sheet1! A: A, A2, Sheet1! C: C) cell C2 cell input formula (variety 3 + 4 formula) = SUMIF (Sheet1! A: A, A2, Sheet1! D: D) + SUMIF (Sheet1! A: A, A2, Sheet1! E: e)

How many ways to write the summation formula of arithmetic sequence?

Sn=n(a1+an)/2
Sn=na1+n(n-1)d/2=dn^2/2+(a1-d/2)n