Multiply multiples of columbs by a set column amount

[d3ell]

Hi Excel Experts!

I have a query that has long been an issue to me, I usually find a fix or ways lo learn formulas by searching the net however on this occasion I cannot seem to find anything - possibly because I don't really know how to explain what I want to do. I'm also pretty sure the formula will be a dead easy one for someone who can see/understand what I'm talking about!

I basically have a set of "extra options" for a customer - below this extra option is a price for this option per qty.

The extra options are set out in the columns with the price below. I have multiple columns with all different extra's and all different extra costs.

I'm wanting to add a qty in the "plot no. row" and at the end of the row have a total!

If you open the workbook attached you will see that I have found a way to do this and probably understand better what I mean, however the formula is huge and if ever I want to add an addition column / customer extra I have to create the massive formula.

If you could either solve this formula for me, or alternatively point me in the right direction towards how to describe what I want to do then that would be muchos appreciated!

thanks

[jjhayes]

Does this formula

Please Login or Register  to view this content.

put in AE4 and copied down do what you want?

[VictorOnline]

Hey there!

Here's a quick fix for you. I hope I understood your issue correctly!

If this works for you, pay attention to the brackets.You'll get those by tiping in your formula then pressing ctrl+shift+enter which indicates to excel that you are working in an array.

[José Augusto]

Hi
Try this in AE4 and copy down

Please Login or Register  to view this content.

[jimmiboy]

hi everybody

i hv colomn where numbers are repeating many times how i can make identical them without deleting any of them attached herewiht sheet

[José Augusto]

Hi @jimmiboy
I suppose you must create a new thread. This is a new problem. Title don´t match.

[d3ell]

Hi Everyone! - thanks so much for the help! - All of the formulas recommended do exactly as I wanted! - Actually a harder formula than I thought it would of been! never come across the =SUMPRODUCT. so much appreciated for all your help! You guys are Good!