Help with Formula Please

[Fred]

I am trying to produce a table that shows how many items per type that
a buyer buys, the toal number of items by type bought and the total
cost of each sale.

I am getting in a real muddle and would be very grateful for some
help.

I have a spreadsheet that has columns as follows starting with A:

A................to ...............CZ TOTAL
Item Des...................
Item Cost..........................
Buyer A............................. £35
Buyer B......................................£70

I enter the amount of items that a buyer buys in a each item column.

Using this number and the Item cost I can work out the total cost per
item. The fomula for the Total column is $b$3 (item cost) *no of items
bought

I should be able to copy and paste the formula down each row but
doing this for each item/column in the spreadsheet (over 100 columns
!) is very time consuming,

If anyone knows an easy way to do this, than I would be very grateful
for some help.

Yours Fred

 

[Frank Kabel]

Hi
enter a formula like
=$B$3*B4
and copy this down. see:
http://www.cpearson.com/excel/relative.htm

 

[Fred]

Franks

Thanks but the crux of the problem is - is there an eaiser way o
completing a formula

=($C$2*C4)+($D$2*D4)+($E$2*E4) etc etc up ($AZ$2*AZ4

rather than just adding individual cell data. I have tried sum an
sumproduct but am getting errors

Many thanks for your help - much appreciated

Yours Fre

 

[Aladin Akyurek]

[...]

the crux of the problem is - is there an eaiser way of
completing a formula :

=($C$2*C4)+($D$2*D4)+($E$2*E4) etc etc up ($AZ$2*AZ4)

rather than just adding individual cell data. I have tried sum and
sumproduct but am getting errors.

If that works, then:

=SUMPRODUCT($C$2:$AZ$2,C4:AZ4)

also would.

 

[Fred]

Aladin

If that works, then

=SUMPRODUCT($C$2:$AZ$2,C4:AZ4

Just the job - many thanks. My error was that I thought had to a
somewhere in the sumproduct equation

Many thanks for your help

Fre

 

[RagDyeR]

Well I'll be darned!
This is one of the very rare times that I've seen this used just as Redmond
"says" it should be used.<bg>
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


[...]

the crux of the problem is - is there an eaiser way of
completing a formula :

=($C$2*C4)+($D$2*D4)+($E$2*E4) etc etc up ($AZ$2*AZ4)

rather than just adding individual cell data. I have tried sum and
sumproduct but am getting errors.

If that works, then:

=SUMPRODUCT($C$2:$AZ$2,C4:AZ4)

also would.