What is this type of formula called?

[tails1]

Hi,

Attached is an order tracker I inherited from a small stockroom I've been tasked with running. I understand most of the processes on the document such as freeze panes and the referencing another sheet.

On row C33 onwards there is a huge formula. I understand what it is doing (absolute reference to column B multiped by column C and added together. Is this called in array? If it is what is the specific Excel term as you would not want to manually enter that.

I want to increase the order tracking to cover around 500 items of stock. How do I increase this formula string quickly? Also if I want to add a row is it as simple as inserting a row on each tab?

Ideally I'd add a couple of columns to the freeze panes for Stock section and SKU code. Any other tips greatfully received.

How do I award points for helpful answers as I, just click add reputation?

Thanks very much.

[6StringJazzer]

That long formula is just a formula. There is no special name for it. However, it can be simplified from this

=SUM($B$9*C9)+($B$10*C10)+($B$11*C11)+($B$12*C12)+($B$13*C13)+($B$14*C14)+($B$15*C15)+($B$16*C16)+($B$17*C17)+($B$18*C18)+($B$19*C19)+($B$20*C20)+($B$23*C23)+($B$21*C21)+($B$22*C22)+($B$24*C24)+($B$25*C25)+($B$26*C26)+($B$27*C27)+($B$28*C28)+($B$29*C29)+($B$30*C30)+($B$31*C31)

to this

=SUMPRODUCT($B$9:$B$31,C9:C31)

The other questions will require a little more analysis.

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name. This will award reputation points, which have no material value but are a great source of pride.

[tails1]

Great so if I had around 500 items I could just put something like =SUMPRODUCT($B$9:$B$500,C9:C500)

I'll give it a go.

Who has the highest reputation?