# 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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…