Excel Help - Cell Referencing

  Taff™ 16:07 01 Oct 09
Locked

I have in cells B1, C1, D1 etc some Ticket Prices and in Column H I want totals for these tickets according to the number ordered in each row. i.e. If Row 3 reads 1-1-2 I want the total value of these tickets displayed in H3. I can get th first row formula right but how do I "Copy" This down so that every row references B1, C1, D1 etc and multiplies to give the corect answer in column H?

  Picklefactory 16:15 01 Oct 09

If I'm understanding correctly, you have prices in B1,C1,Di and below those in continuing rows you have number of tickets bought at each price.
If that is correct, then in H2 copy/past
=SUM((B2*$B$1),(C2*$C$1),(D2*$D$1))
Click/drag that down and it should do the job.

  Taff™ 16:55 01 Oct 09

Spot On Picklefactory. Thanks

This thread is now locked and can not be replied to.

Surface Pro 5 News - release date, UK price, features, specs

Gear VR vs. Daydream: Which delivers the best VR experience?

iPad Pro 12.9 vs Surface Pro 5