LogFAQs > #879336396

So I have a column full of numbers I need to sum up, say A1:A10 are the numbers I want to sum.

However cell B1 has a number like 3 in it. The sum will go in C1.

Now, the tricky part is I only want to Sum the first X numbers of the A1:A10 range, where X = B1.

So if B1 = 3, I only want to sum the first 3 numbers.

Is there an easy way to do this? Basically something like:

=sum(A1:A"=B1")

if that makes sense...
---

Hello world!