Excel Help and Problems

[etech0]

in a sumif, i want to add up all the values for certain states on the list, but im excluding a few. is there a function to nest inside the sumif that i can use for this to list the few im excluding?
thanks

Sounds like DSUM would be a better option.
http://www.techonthenet.com/excel/formulas/dsum.php

Basically, you set up another small table with the criteria you want.

[dealfinder85]

Sounds like DSUM would be a better option.
http://www.techonthenet.com/excel/formulas/dsum.php

not sure thats gonna help
i need to include in the function the list of states im excluding, that i dont want to add up those values corresponding to those states

[etech0]

not sure thats gonna help
i need to include in the function the list of states im excluding, that i dont want to add up those values corresponding to those states

Should be possible. Give me a minute...

[dealfinder85]

Should be possible. Give me a minute...

figured out a less technical way to do it
thanks though

[etech0]

figured out a less technical way to do it
thanks though

NP. I'm curious now, so I'll keep looking

BTW you might want to look into sumifs

[lubaby]

figured out a less technical way to do it
thanks though

Added a new column and deleted the ones you don't want?

[etech0]

Got it - your small table should look something like this:

State  State  State
<>NY <>NJ  <>CT

etc, for all the states you don't want

[dealfinder85]

Got it - your small table should look something like this:

State  State  State
<>NY <>NJ  <>CT

etc, for all the states you don't want

thanks

[PTU]

in a sumif, i want to add up all the values for certain states on the list, but im excluding a few. is there a function to nest inside the sumif that i can use for this to list the few im excluding?
thanks

just put a minus sign in your formula  by those states?

[lubaby]

have a few 100K rows and i need to convert a column from text to number
i know if you highlight them then that thing pops up where you can, but that keeps freezing my excel
another option?

Make a cell with the number 1 in it, copy that cell, then do paste special over the entire column, there should be an option to Multiply. Should work.

[dealfinder85]

Make a cell with the number 1 in it, copy that cell, then do paste special over the entire column, there should be an option to Multiply. Should work.

thanks

[smurf]

Make a cell with the number 1 in it, copy that cell, then do paste special over the entire column, there should be an option to Multiply. Should work.

use text to columns. Don't select a delimiter and choose the cell type you want.

[jackofall]

I overwrote data on an excel sheet how do I restore to a previous version? I right-clicked on the file and there is no previous version saved, any suggestions?

[etech0]

I overwrote data on an excel sheet how do I restore to a previous version? I right-clicked on the file and there is no previous version saved, any suggestions?

I'm assuming you tried control-z?

[jackofall]

I'm assuming you tried control-z?

I saved the wrong data by mistake.

[menachem_m]

Is there any formula to calculate an average daily balance for a set date range? When downloading BOFA data to excel, it only provides a row for days with activity, so I can't just do a simple average function. Or a quick way to 'fill in' all the missing days with the same balance as the previous day?

[lubaby]

Is there any formula to calculate an average daily balance for a set date range? When downloading BOFA data to excel, it only provides a row for days with activity, so I can't just do a simple average function. Or a quick way to 'fill in' all the missing days with the same balance as the previous day?

That would be simpler. Done so many times. 

Not by a computer now, but IIRC the logic is "If cell is empty, use cell above it, otherwise use cell". Try in a new column next to the column with missing data.

Will check back once by a computer with an exact formula.

[MarkS]

1. Select the range that contains blank cells you need to fill.
2. Click Home > Find & Select > Go To Special…, and a Go To Special dialog box will appear, then check Blanks option.

3.Click OK, and all of the blank cells have been selected. Then input the formula “=A2” into active cell A3 without changing the selection. This cell reference can be changed as you need.

4. Press Ctrl + Enter, Excel will copy the respective formula to all blank cells.

5. At this point, the filled contents are formulas, and we need to convert the formals to values. Then select the whole range, right-click to choose Copy, and then press Ctrl + Alt + V to active the Paste Special… dialog box. And select Values option from Paste, and select None option from Operation.

6.Then click OK. And all of the formulas have been converted to values.

[jackofall]

I have a set of data and would like any tips of the best way to present it so one can see the trends easily.
Column A - Month
Column B - Payee
Column C - Service Provided (there are only 3 choices)
Column D - number of items
Column E - Total cost of items

I would prefer some sort of chart.

Any help is greatly appreciated.
TIA

[lubaby]

I have a set of data and would like any tips of the best way to present it so one can see the trends easily.
Column A - Month
Column B - Payee
Column C - Service Provided (there are only 3 choices)
Column D - number of items
Column E - Total cost of items

I would prefer some sort of chart.

Any help is greatly appreciated.
TIA

Excel has a great Pivot Chart feature built in. Should be exactly what you're looking for.