Question about Microsoft Computers & Internet

# Identifying Cells which add up to a desired result

Hi, I have a spreadsheet as follows
Column A
1 17 23 34 54 67 18 23 15 3
I would like a formula which identifies all cells either singly or together with a another cell which add up to say 18.

Thanks

Ronnie

Posted by on

• ronnie999 Sep 09, 2008

Hi, Ok I will try to simplify it here.

Row Column A Column B

1 Type of Fruit

2

3

4

5

6

• ronnie999 Sep 09, 2008

Hi, Ok I will try and simplify it here

Row Column A Column B

1 Product Qnty

2 Disks 285

3 Scanners 256

4 MO Disk 24

5 Plasma 2,125

6 Ext Storage 280

7 laptop A 200

8 Laptop B 80

Problem: I need excel to tell me which cell or cells from B2 to B8 add up to the number 280.

From a visual inspection I would say B3&B4, B6 and B7&B8. But I would like Excel to do this for me automatically.

Thanks

Ronnie999

• ronnie999 Sep 09, 2008

Hi, Ok I will try and simplify it here

Row Column A Column B
1 Product Qnty
2 Disks 285
3 Scanners 256
4 MO Disk 24
5 Plasma 2,125
6 Ext Storage 280
7 laptop A 200
8 Laptop B 80

Problem: I need excel to tell me which cell or cells from B2 to B8 add up to the number 280.

From a visual inspection I would say B3&B4, B6 and B7&B8. But I would like Excel to do this for me automatically.

Thanks
Ronnie999

• ronnie999 Sep 09, 2008

Hi, Would really really require some help on this. Thanks

×

• Level 2:

An expert who has achieved level 2 by getting 100 points

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.

• Expert

Hi

yes it can be done using if function.
example of how to use if function,
IF(A1=B1,C1,D1)
this wl print the value at C1 if value at A1 and B1 is equal else it wl print value at D1

You can try with this.
I too wl be trying and now for exact solution.

Goodluck

Posted on Sep 09, 2008

• Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Genius:

An expert who has answered 1,000 questions.

• Master

I get your point. But thinking of it is kinda complicated. The formula I believe is a combination of Nesting IF and VLookup but its hard to do it. Better consult some excel pro or accountant to simplify what you want.

Posted on Sep 09, 2008

• Level 3:

An expert who has achieved level 3 by getting 1000 points

Superstar:

An expert that got 20 achievements.

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

• Microsoft Master

Haven't used excel in a while. I would use the IF function to tell me if this and this adds up to 280

http://www.timeatlas.com/mos/5_Minute_Tips/General/Excel_Basics_and_the_IF_Function/

Posted on Sep 09, 2008

• Level 3:

An expert who has achieved level 3 by getting 1000 points

Superstar:

An expert that got 20 achievements.

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

• Master

What do you want to add up to 18? once I understand exactly what your trying to do I will be able to assist you further.
Thanks,
Lee

Posted on Sep 09, 2008

×

Hi,
A 6ya expert 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 repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

To subtract 10 from 20 and have the answer appear in cell C3: Click on cell C3 with the mouse pointer to make it the active cell; Type the equal sign ( = ) in cell C3; Click on cell A3 with the mouse pointer to add that cell reference to the formula after the equal sign;

? 5:36
there this is another tutorial on Google spreadsheet and in this tutorial you. we are going to see how you can ...

? 1:07
This Tutorial Shows the formula how to Subtract Cells in a Spreadsheet from Google Docs from the Drive ...

Mar 13, 2018 | Google Computers & Internet

### In Excel adding positive and negative numbers

Yes,

1. Select the column. (click on top of the column it will select)
2. Right Click and select Format Cells.
3. Select Currency in Category then press OK
Now just type your Numbers i.e. 571 for \$571 and -650 for -\$650 and sum using the normal way.

That is Select the Cells which you want to SUM and Press Alt+=

This will bring the total just below the selected cells.

Thanks
Iqbal

Apr 02, 2008 | Computers & Internet

### How do I copy a formula down a column in a spreadsheet

I'm not sure.......try right clicking and holding down the right hand corner of the cell that has the formula, then drag it down into all the other cells in that column.

let me know
Joe

Mar 04, 2017 | Formula Computers & Internet

### How do i subtract two cells and progress down a row by a day so the next day the formula subtracts the current day and previous day?

You have to start the sequence with a slightly different formula because there is no preceding value for Monday.
The rest of the formulas are running totals so they are the same just dynamically duplicated down the column add infinitum.
Just duplicate the the formula Picking up the value form the result column and subtracting the next running subtraction value.

Mar 06, 2015 | Microsoft Excel 2010

### How do I check that I have copied the formula to a new cell?

Click on the column-heading to select the entire column.
Right-mouse-click to select "copy".
Move the mouse-pointer to where you want the copy to appear.
Right-mouse-click and choose "insert copied cells".

Sep 16, 2014 | Microsoft 1994 Office Excel Spreadsheet...

Julie, It sounds like the spreadsheet might be locked.

Jan 02, 2014 | Soda iSpreadsheet

### Excel formula

Use the COUNTIF command. The COUNTIF command can count the criteria for a range of cells. Since you can only use it for one range of cells or criteria, you simply add another criteria to the formula as follows: =COUNTIF(AG1:AG5,"X")+COUNTIF(Sheet2!L1:L6,"X")

Apr 10, 2009 | Microsoft Excel for PC

### If/Then Formula

not really
Just create the
formula =if(e1=1,"X",if(e1=2,"Z","")) in cell K1 then
formula =if(f1=1,"X",if(f1=2,"Z"),"") in cell L1 then
formula =if(g1=1,"X",if(g1=2,"Z","")) in cell m1 then
formula =if(H1=1,"X",if(h1=2,"Z","")) in cell N1 then
if you wanted another statement
formula =if(H1=1,"X",if(h1=2,"Z",if(h1=3,"Y,""))) in cell N1
this is nesting the if statement you just keep adding conditions.
What you are asking I have to type this in 600 times
No just do one line and then highlight the cells with the if in it and then select copy from edit menu or right click and select copy
Then click on next 599 cells by clicking on first cell and hold mouse button down and drag down mouse to last 1000 row of cell and right click mouse and select paste. The formulas will alter accordingly as pasted to each cell

You could also use a vlookup statement
you open another workbook look at bottom of worksheet for tabs to add a workbook.
Then you create a table in other workbook
1 cell A1 H in B1
2 cell A2 Z in B2
https://www.timeatlas.com/vlookup-tutorial/
you would still need to copy the cells down

Mar 30, 2017 | Microsoft Office 2003 Basic Edition...

### Excel will not displaying the results of a trend array formula

Hi Griffnz,

Your "known Y's" or 'values' are in Column B. This is the first array in the Trend formula.

Your "known X's" or 'months' are in Column A. This is the second array in the trend formula.

The trend formula is supposed to give you a projection of what the rest of the values in Column B will be over the next few months (usually continuing cells in Column A). The cells you want these values to show up in represent the third array in the formula.

Thus, your formula should look more like: '=trend(B3:B14,A3:A14,A15:A18)'

However, your formula is leaving out The values in B and adding values from C - -- but there ARE no values in C. Apparently, C is where you want the values to appear. In that case, the C array would be the third array in your formula. This would look more like '=trend(B3:B14,A3:A14,C3:C14)

If this doesn't make sense, let me know.

Sep 30, 2008 | Microsoft Excel for PC

### Percentages in Excel

No problem, Melinda, I am here to help!

A B C D
1 Question Yes No Total
2 Is sky blue? 20 2 22
3 Is world round? etc.

In this case, the formula for % of Yes would be: =B2/D2. This would give you a decimal point result such as 0.909091. Now if you want to make this look like a percentage in your spreadsheet, just do the following:
1) click on the cell where you have the division formula
2) clck on Format in the top menu bar
3) click on Cells
4) click on the Number tab (if you're not already there)
5) click on Percentage in the list of categories
6) click OK

To boil it all down to a simple principle, percentages are created in Excel by dividing the two numbers using a formula with "/" in it, and then formatting the result to look like a percentage instead of a decimal.

I might have misunderstood your question, and I have an idea of what else you might have been asking (and another slightly more complicated solution for it!), so please let me know if my first answer didn't hit the mark!

Good Luck!
Regards,
RichMTech

Aug 08, 2008 | Microsoft Excel for PC

## Open Questions:

#### Related Topics:

98 people viewed this question

Level 3 Expert

Level 3 Expert