Question about Microsoft Excel for PC

# Formaul I have the following formula on sheet 37, =sum('game 1'!c5). I want to use the formula in the following manner. I have 36 sheets each sheet is named game 1 thru game 36. I want to take the above formula and use the the fill handle to pull data from the indicated cell (c5) on the 37 th sheet. The way I can do it is to use the formula icon on a cell then go to the respective sheet and hit enter. It would be easier to use the fil handle, however, I don't know what to put in the formula to go from sheet 1 thru 36. I hope I've explained my self correctly.

Posted by on

### Biju Panjikaran

• Level 1:

An expert who has achieved level 1.

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that hasĀ over 10 points.

Mayor:

An expert whose answer gotĀ voted for 2 times.

• Contributor

You have to use the reference Do you know how to use it

Posted on Apr 01, 2008

## 1 Suggested Answer

### 6ya staff

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

Complete. Click "Add" to insert your video.

×

## Related Questions:

### How solve the problem to enter 13.5% tax rates to tally

Spread sheet ...your total = 13.5% correct???

Sum the col or row lets call it r5 c4. go to r6 c5 and enter "= r5 c5 * 13.5%"

Go to r7 c5 and sum r5 c5 + r6 c5.

Thnks for your quesiton at FixYa.com

Nov 23, 2010 | Health & Beauty

### Excel sum formula problem.

Please send the file to my email address [email protected] and I will review the question.

Apr 28, 2009 | Microsoft Excel for PC

### Excel formula related to a date range

Use the IF and Date functions together. On sheet 3, put the birthday (3/15/1954) in cell B1, put the beginning date (1/1/1946) in cell C1 and the ending date (12/31/1964) in cell D1.
Then on Sheet 1, but the following formula in the cell you want an X to be placed in.
=IF(AND(Sheet3!B1>=Sheet3!C1,(Sheet3!B1<=Sheet3!D1)),"X"," ").
Make sure you type the formula Exactly as it appears.

Mar 20, 2009 | Oracle Database Enterprise Named User Plus

### Not able to build a formula

i don't think you can sum or count a range that crosses sheets. :)

Nov 14, 2008 | Microsoft Computers & Internet

### Copying data from one sheet to another if two fileds match

Nope, sorry, although I am truly an expert at Excel formulas, I do not understand what you are trying to end up with in the final cell. We can compare a specified field with two spreadsheets - use named ranges and index/match lookup formulas. But then where you really lose me is in reading "a generic field" to find a match, and then placing what "data from another field" into what "other sheet" - ? See the confusion?

Best way to compare 2 given parameters would be to use a nested if formula, with index/match combo. Here is a simple Excel example of how such a formula could be structured:

Sample Data (columnar arangement):
A1: Part B1: Code C1: Price D1: Find Part E1: Find Code
A2: x B2: 11 C2: 5.00 D2: y E2: 12
A3: x B3: 12 C3: 6.00 D3: y E3: 11
A4: y B4: 11 C4: 7.00 D4: x E4: 12
A5: y B5: 12 C5: 8.00 D5: x E5: 11

To retrieve the price for part y with code 12 and return the value to cell F2, type the following formula in cell F2:
=INDEX(\$C\$2:\$C\$5,MATCH(D2,IF(\$B\$2:\$B\$5=E2,\$A\$2:\$A\$5),0))

Press CTRL+SHIFT+ENTER to enter the formula as an array formula. The formula returns the value 8.00.

To take this one step further, with range names, this example will find one value at a specified location which matches a specific row header value and column header value. Let's say the range is home values (Range=HomeVal), Column A of HomeVal contains street addresses,"row headers" (Range=StAddress), and Row 1 contains dates of the various values that are in the body of the table, "column headers" (Range=Dates). To return the specific value from the range HomeVal to another sheet, where A1=address specified and A2=date specified:

Then make sure to press CTRL+SHIFT+ENTER to enter the formula as an array formula - if you only hit enter, these types of formulas will not work properly.

Please post back if you need further help, with more details, otherwise thank you for using and rating FixYa!

Jul 08, 2008 | Microsoft Computers & Internet

### Sumproduct or conditional sumif with multiple criteria in vba code...

i'll just reply to your conditional sumif query.

yes, you can do multiple criteria query but with a matrix formula. you may look it up. nonetheless, here is how one would look like:

{=sum(if(range1=A x range2=B x range3=C, sum range))} note that x (multiplication) is used to denote intersection of the criteria

initially, you'll enter it as:
=sum(if(range1=A x range2=B x range3=C, sum range))

then, edit the cell (F2) and press ctrl+shift+enter for the brackets { } to appear.

Jun 27, 2008 | Microsoft Excel for PC

### Excel formula

CHOSE THE PERTICULAR CELL WHERE THE SUM IS GOING TO BE DISPLAYED AND HYPERLINK IT IT WITH SHEET 2

Apr 12, 2008 | Microsoft Excel for PC

### Excel Coordinates don't show up in Formula Bar

Heyo. I have had this problem before too. This procedure prevents the cells that contain the formula from being edited.
1. Select the range of cells whose formulas you want to hide. You can also select the entire sheet.
2. On the Format menu, click Cells, and then click the Protection tab.
3. Select the Hidden check box.
4. Click OK.
5. On the Tools menu, point to Protection, and then click Protect Sheet.
6. Make sure the Protect worksheet and contents of locked cells check box is selected.
Good Luck!
Wayne

Dec 28, 2007 | Computers & Internet

### Formula required

at first select the 1st page data and select data-subtotal from the upper menu list.
then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks

Dec 04, 2007 | Microsoft Excel for PC

### Creating a report

I assume you are using excel? to get the new sheet auto update try this formula =sheet1!C5 into the new cell in new sheet (eg. sheet2) whenever you update sheet one cell C5 it will automatically appear in new sheet...

Aug 29, 2007 | Microsoft Office Standard for PC

## Open Questions:

#### Related Topics:

190 people viewed this question

## Ask a Question

Usually answered in minutes!

Level 3 Expert

Level 3 Expert