First  |  Prev |  Next  |  Last
Pages: 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218
Calculate total metric based on sum of metric over specific time f
I am trying to calculate the sum of specific metrics as they occur over a certain time period. You can find the spreadsheet I'm using here: http://www.staceyboyd.com/excel/example.zip (I had to put it in a zip file, otherwise the browser didn't seem to want to access it.) Basically, in the Total section (s... 2 Feb 2010 17:30
HOW CAN I IMPLEMENT SUMIF(D1:D6,">AVERAGE(D1:D6)")
The subject says it all; the function does not work for me in Excel 2007. ... 27 Jan 2010 17:12
exclude certain cells from series fill
I have a list of files, and I've filled a column to number the files. i want to insert some rows to act as headers to group these files, but I still want to keep the numbered list, in order to keep up the the number of files. Can I fill the column with a series of numbers but exclude the 'header' rows and cel... 27 Jan 2010 14:56
how do I sumif on a font color in excel 2007?
I would like to do a conditional sum of a color coded column of numbers. Is there any way to do that in Excel 2007? ... 27 Jan 2010 10:23
countif with time
Col A 09:15 12:39 10:15 09:25 11:36 I need to count the number of times there is an entry in column A that is between 08:00-08:59, 09:00-09:59, 10:00-10:59, etc. So the sum would be 08:00-08:59 0 09:00-09:59 2 etc. ... 26 Jan 2010 23:25
Inserting a blank row between rows of data
I have three Excel 2007 lists, around 200 rows each. I've now found I need to insert a blank row after each list entry. Is there any easy way to do this? I'm pretty decent with Excel, but don't know VBA. I thought of recording a macro, but didn't know how to edit it so that I wouldn't have to repeat the sam... 2 Feb 2010 17:30
Is it possible to count the no. of characters in a cell in Excel?
In order to create Tweets in Excel, I wanted to know if you could count the characters/spaces in a cell. ... 26 Jan 2010 15:33
Bond premium amortization using the constant yield method
Anyone know of a function that calculates the bond premium amortization using the constant yield method? An example of a bond premium that would need amortizing would be: Par: 100,000 Price: 101 Bought: July 15, 2009 Maturity: June 30, 2019 Cash Paid: 101,000 Premium: 1,000 Coupon: 5% paid semi-ann... 26 Jan 2010 15:33
Addition Error
If i type to A1, "r"(not quote) and B1 "1"(not quote), and C1 "=A1+B1"(not quote), i'm taking an #Value error... How can i solve this issue? ... 26 Jan 2010 15:33
First  |  Prev |  Next  |  Last
Pages: 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218