need help with a calculating feild

**rob.rg** · 01-17-2008, 06:51 AM

hello everyone i just need some help on a calculation formula, basically i have three rows, one called child tickets, one called adult tickets and one called total price, now the child and adult ticket cells are drop down list so i want the total price feild to once someone has entered something into either one or both the ticket cells then for it to pick up information on pricing i have on a seperate sheet, i have already worked out a formula for this but you have cant drag it down and for it to work in all the other cells, this is the forumla i worked out but i need a better one please

=SUM(D9*'Standing data'!C5+'Week 1, barcelona'!E9*'Standing data'!D5)

standing data is the sheet in which it has all the costs and stuff please help me thanks rob

**NBVC** · 01-17-2008, 10:02 AM

so are you saying that when you drag down the formula you don't want certain cell references to change?

If so, just add $ signs in front of the column and/or row identifier(s) for the cell references you don't want to change. Then copy down.

For example.... if you want to "freeze" cells C5 and D5 on the Standing data sheet, then try something like:

Please Login or Register  to view this content.

note... for consistency, I assumed that the first D9 reference was on the Week 1, barcelona sheet and so added that information...

Edit:

You can also use Sumproduct to reduce the size and repetitiveness....

Please Login or Register  to view this content.

need help with a calculating feild

LinkBack

Thread Tools

Rate This Thread

Display

need help with a calculating feild

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions