equation does anyone know how to do Capital-sigma notation ?(x-n)*Y^n from n = 1 , to n = x assuming i have to enter x, and y Gaurav wrote: Re: Please Help with complicated SUM formula 01-May-08 Glad I could help. Previous Posts In This Thread: On Thursday, May 01, 2008 4:08 PM mr wrote: ... 16 Feb 2010 07:31 input time by keybrd in locked worksheet What I want to do is have a user input time start and end in a time sheet to account for worked hours by using a short cut key stroke but I don't want him to be able to just enter anytime he wants. By using the shortcut excel would enter the exact time. Can I do with with locked cell or how else? ... 16 Feb 2010 18:23 Sum Days into Weeks I would like to save myself a whole lot of work please... I have two spreadsheets, one has all the days of the year across the columns, and the next has all the week ending dates across the colums. What I need to do is sum the data in each of the rows below the daily dates into weekly chunks on the same rows in t... 16 Feb 2010 00:27 how do i calculate a % i need to calculate a % i need to give a percentage to a mark of 67/70 and make it 30% of the total i need help ... 16 Feb 2010 07:31 Countif query Take 2 - I don't think my first request got sent. I am attempting to count the number of cells in AB2:AB26 that have a number less thn zero. I have attempted this formula without success: =COUNTIF(AB2:AB26,<0) ... 15 Feb 2010 21:10 Date formula Hello I need a formula that add 13 days to a given date. Example of this is that I have a date in cell F10 (01/02/10) and I want cell F11 to appear as (14/02/10). Thanks in advance. ... 15 Feb 2010 17:48 Sorting with sumif function HI, I have a worksheet with 5 columns of data and 100 rows. in one of the columns I have a sumif formula. When I try to sort the data the cell reference in the sumif column doesn't change however, the other column do change. Is this normal or am I doing something wrong? Thanks for any help ... 15 Feb 2010 18:56 vlookup and multiple criteria I have an spreadsheet with columns like: col A col D col E colF B230 8 1 0 F001 -5 0 10 F002 3 20 0 F010 5 -29 3 F014 40 ... 15 Feb 2010 13:14 Looups and multiple criteria I have an spreadsheet with columns like: col A col D col E colF B230 8 1 0 F001 -5 0 10 F002 3 20 0 F010 5 -29 3 F014 40 ... 15 Feb 2010 10:57 Lookup and multiple criteria I have an spreadsheet with columns like: col A col D col E colF B230 8 1 0 F001 -5 0 10 F002 3 20 0 F010 5 -29 3 F014 40 ... 15 Feb 2010 10:57