Get % based on last number in column

[JTL9161]

I am trying to get an percentage for column A1:A100 using the last number in column B6: B50. A new number is added to column B each week.

So I sum column A (for example: 692) and then need to take the last number in the range in column B (for example 15) multiply by 150 then take the 692 and divide by 2250 to equal 31%. The 150 is an constant number to multiply by.


Thank you,
James

 

[Sergius]

Hello! Can you provide a fragment of your data? Where, for example, there is a cell with a number of 150, etc.

 

[JTL9161]

the actual 150 can be put directly into the formula or just put any cell (C1 for example)

 

[Fluff]

How about

=SUM(A1:A100)/(LOOKUP(10^9,B1:B50)*150)

 

[saboh12617]

Hello,

I think the formula below answers the question.

=LET(colB;B1:B100;
lastVal;INDEX(colB;XMATCH(TRUE;ISBLANK(colB);0;1)-1);
SUM(A1:A100)/lastVal*150)

Replace the “;” with “,” if needed.

 

[JTL9161]

Perfect, thanks!

 

[Fluff]

Glad we could help & thanks for the feedback.

@saboh12617 I would suggest that you test your formula before posting it.