Excel Help - Cell Referencing

  Taff™ 16:07 01 Oct 2009
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 2009

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 2009

Spot On Picklefactory. Thanks

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

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

Adobe shows still-in-development tools, including automatically colourising black-and-white photos

iPhone X news: Release date, price, new features & specs

Comment transformer un iPhone en borne Wi-Fi ?