Question about Microsoft Computers & Internet

4 Answers

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

  • 2 more comments 
  • 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

×

Ad

4 Answers

  • 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
  • 97 Answers

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

Ad
  • 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
  • 1,269 Answers

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

Ad
  • 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
  • 13,433 Answers

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
  • 4,472 Answers

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

×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Need a formula to add and subtract in google sheets


Subtracting in Google Spreadsheets - ThoughtCo

https://www.thoughtco.com > ... > Spreadsheets > Google Spreadsheets
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;

Google Spreadsheet Formulas : How to Add, Subtract, Divide, and ...

? 5:36
https://www.youtube.com/watch?v=byTDwUQAwnE May 28, 2014 - Uploaded by Helpfolder
there this is another tutorial on Google spreadsheet and in this tutorial you. we are going to see how you can ...

How to Subtract Cells in Google Spreadsheet - YouTube

? 1:07
https://www.youtube.com/watch?v=p-Frr5coC_4 Feb 16, 2014 - Uploaded by Google Sheets
This Tutorial Shows the formula how to Subtract Cells in a Spreadsheet from Google Docs from the Drive ...
formula to add and subtract in google sheets Google Search

Mar 13, 2018 | Google Computers & Internet

10 Answers

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
b6298df.gif 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

1 Answer

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

1 Answer

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.
25525374-qztzwsd5tae24twsq5kxbvm0-3-0.jpg The rest of the formulas are running totals so they are the same just dynamically duplicated down the column add infinitum.
25525374-qztzwsd5tae24twsq5kxbvm0-3-2.jpg 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

1 Answer

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

1 Answer

Add columns


Julie, It sounds like the spreadsheet might be locked.

Jan 02, 2014 | Soda iSpreadsheet

1 Answer

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

1 Answer

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

2 Answers

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

1 Answer

Percentages in Excel


No problem, Melinda, I am here to help!

If I understood correctly, your spreadsheet looks something like this:
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

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

98 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2983 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...