Identifying Cells which add up to a desired result

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

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

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.

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

Hello this is Baris,
Can you tell me more about this employee. Are you creating an excel spreadsheet to keep record of his days. Are you just getting the numbers from an outside source like a schedule.

To be able to give you an answer I will assume that you have the info already in the same spreadsheet.

Lets say Column A is the days of the month.
Column B is the information column like the hours that the employee worked. If the month has 31 days this is what you need to do.
Click on the cell B32 and type the formula
=count(B1:B31) and press enter. This will count the number off cells which have a value in it in that month.

If you provide me more info we may come up with a better solution. Hope this helps :)

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")

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

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.

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