Question about Microsoft Office Professional 2007 Full Version for PC

# Show the sum of the cells that matches with a given output

Suppose i have an amount that may be the sum of different cells in a column .I want to find out which cells sum up to the amount given

Posted by on

• Level 1:

An expert who has achieved level 1.

Corporal:

An expert that hasĀ over 10 points.

Problem Solver:

An expert who has answered 5 questions.

• Contributor

If the cell with the sum in it was created by a formula then you could use the formula to find out which cells were selected when creating it. for instance...

the sum of cells A1 - A9 would look like =sum(A1:A9)

http://www.contextures.com/xlFunctions01.html

Posted on Feb 11, 2009

Hi,
a 6ya Technician can help you resolve that 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 repair professionals here in the US.
Goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### Setting up a formula. I am comparing amounts for the last 3 years of raises and want to figure 5 different ones this year.Example of what I am trying to do. =(F6:F18*1.12%+F6:F18) Can this be done?

in excel ?
=sum(f6:f18)*0.012+sum(f6:f18)
if each row has to be individually * 0.012 add a column and put in this column each row cell * 0.012. example new column G then g6=f6+f6*0.012
a screen print of what you are trying to do would give a clearer indication of exactly what you want to achieve ?

Mar 26, 2017 | The Computers & Internet

### I have three columns that equal a sum column. I now want to take the sum column and find out what 3.33 percent will be. This is a commission.

=SUM(A1,B1,C1)*3.33% or =SUM(A1,B1,C1)*.0333
(A1, B1, C1 are the cells that contain the sum of the individual columns.
=SUMCOLUMN * 3.33% (enter the cell of the sum for the three columns) = C24*3.33%

3.33% =0.033
=CELL * 0.0333
=CELL * 3.33%

May 12, 2016 | Microsoft Excel for PC

### Sum numbers in a column down until you come to a blank, then start again

Sounds like your issue can be solved readily with a pivot table.
If you give the columns of names a title like "NAME" and the number columns a name like "VALUE". All other columns should contain a unique name.

Then select the entire table, including the labels at the top ensuring that the range extends entirely over the column you need to sum the values of.

In Excel 2013, choose the INSERT menu and select the PIVOT TABLE command.
Insert the Pivot table into a new worksheet.
A new sheet will open with a strange-looking control panel on the right of the window.
Make sure that the box for NAME and VALUE (only) are checked

You will notice that Excel assumes that you want the SUM of the values for each NAME summed. The results are in the leftmost area of the worksheet.

Sep 03, 2014 | Microsoft Excel for PC

### Finding the correct row num

You would have to combine the use of 2 functions. The Address and Match funbctions.
Lets say the number you want the address of is located in cell F1 and you have 2 columns of numbers. One colum in Column A and the other in column B. I will give you 2 formulas. The 1st one will return just the row number. The 2nd one will return the cell address.

Option 1: Lets say you just want to know the row reference of the number in cell F1. Place this formula in cell D1. =MATCH(F1,A1:A20)
If you have another column ytou want the row number of, place the formula in lets say cell D2 and change the column references from 'A' to 'B'.

Option 2: If you want the cell reference, place this formula in cell D1 and D2 instead of the firt formula.
And just like the first option, for the 2nd column, put the formula in D2 and change the column reference 'A' to 'B'.

Feb 17, 2009 | Microsoft Excel for PC

### BASIC EXCEL FORMULA

Are you looking to solve any particular problem?--- because there are a huge number of possible formulas in Excel.

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

columns: A B C D
rows
1 20 3
2 10 4
3 15 2
4 1 2 3

Then suppose you type in the following formulas (in the D column):

columns: A B C D
rows
1 20 3 =A1+B1
2 10 4 =A2-B2
3 15 2 =A3*B2
4 1 2 3 =sum(A4:C4)

Then the following answers will appear in the D column:

columns: A B C D
rows
1 20 3 23
2 10 4 6
3 15 2 30
4 1 2 3 6

Sep 29, 2008 | Microsoft Computers & Internet

### Formular to show number and cell references

The formula for A1 is: =SUM(B4,B5)
A2 is: =SUM(C4,C5)
A3 is: =SUM(A1:A2)

To test this, put 25 in cell B4, 25 in cell B5, then 30 in cell C4, and 30 in cell C5.....the result in cell A3 is 110.

Hope this helps.

Mar 07, 2008 | Microsoft Excel for PC

### Excel formula

Assuming that all of your data is in a single row number 4 and between columns N and PF

Try:
{=OFFSET(N4,0,MATCH(TODAY(),N4:PF4,0)+1,1,1)}

The MATCH function looks up the value of today() in the range N4 to PF4 and returns the number of columns offset from the beginning of the range. (The 0 here does an exact match)

The OFFSET function returns a value from a cell a specified number of columns from a reference cell, in this case N4, which is the first column that contains the search data. We need to add on to this value to skip the Interest column.

Regards,
Daryl

Jan 25, 2008 | 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

### Excel Formula

columns total in additin cells of rows equal are total

Oct 24, 2007 | Oracle 10g Database Standard (ODBSEONUPP0)

### Excel argument

If I understand correctly, you want to figure the normal wages at 40 hours and less. If there is more then 40 hours, calculate the normal 40 hours, then calculate the hours overtime (time and a half) and add them to get a total.

B5 columns are filled with this:
=IF(A5>\$B\$1,(\$B\$2*\$B\$1)+((A5-\$B\$1)*(\$B\$3)),A5*\$B\$2)

NOTE: The \$ sign doesn't refer to money, it refers to an absolute reference so when copying a formula, the cell references with a \$ sign are fixed and don't adjust according to the relative position to where it's being pasted.

Oct 22, 2007 | Microsoft Excel 2003 (06503995)

## Open Questions:

#### Related Topics:

122 people viewed this question

Level 3 Expert

Level 3 Expert

Level 3 Expert