Functions

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

formula to calculate amount of hours downtime spent in days
... 26 Jan 2010 14:23