Functions

Question about a Formula
I have a workbook with two sheets. On the first sheet are a series of dates. On the second tab, I am trying to total the number of entries within specific months using date ranges from the first sheet. I can't for the life of me figure out what formula to use to do this. Can anyone help. An example of the ... 23 Dec 2009 13:59

thousands of dollars in cash overflowing your PAYPAL account
Oh thank you so much for this opportunity to become fabulously wealthy for nothing. But I think I will wait a day or two--by that time the pyramid (and this is a pyramid scheme) will have become so big that everybody on earth will be on the list by the time my name comes to the top, and since of course they wi... 17 Dec 2009 13:45

% in Pivot Tables
Hi, I have a pivot table with 2 fields in 'row'. 1st is Job Role, 2nd is Payscale (there are many payscales for each job role). 'Data' is suming the total people for each payscale. I want to get a % of each payscale as a total for the 1st field and not for the whole column or the row. Job Role,Payscale... 14 Jan 2010 20:19

Q on LARGE function
I have the formula below which returns the largest sales day, but what if the largest day covered two days, say Monday & Friday, how could I build that in to my formula i.e. Result could be more than one value? =IF(R197=0,"","Biggest Sales Day = "&INDEX(M188:M194,MATCH(LARGE (S188:S194,ROW(A1)),S188:S194,0))) ... 17 Dec 2009 09:17

Formula mismatch in Excel 2003 & 2007
A formula written (combination of datedif & vlookup) in Excel 2003 does not show the same value when opened in Excel 2007. This is a salary calculation where based on Date of Joining. Yearly increment is due as per date of Joining Suppose the Date of Joining is 10th of Dec The intent is to pay 9 days on the p... 19 Dec 2009 08:22

How do I insert a check box in Excel Vista? I'm a novice
I would like to use a check box rather than inserting a symbol (tick) into the cell. is this possible with Excel Vista? I'm not a programmer so the solution needs to be simple! ... 16 Dec 2009 23:33

Subtotals in Excel 2007 TABLES
Is there any way to insert subtotals (without jumping through hoops like inserting rows and labeling them) into an Excel 2007 "Table"? When attempt is made, the option is grayed out on the Data tab. Any help (and/or workarounds) is appreciated! ... 19 Dec 2009 08:22

Simple Question Complicated Formula
I have a long formula that I'm trying to modify: {=IF(OR(I3>TODAY(),I3=""),"",SUMPRODUCT((Client_Data!$A$3:$A$4000<=$B3)*((Client_Data!$N$3:$N$4000="")+(Client_Data!$N$3:$N$4000>=$B3))*(Client_Data!$K$3:$K$4000=K$2)))} Row 2 includes headers and this formula pulls data from the Client_Data sheet which matches th... 16 Dec 2009 21:21

Calculating length of time with conditions
I would like to calculate the length of time a client spends in a program. We use three columns (entry date, exit date, today's date). If a client is still enrolled I would like to base the length of time on today's date. If the client leaves the program, I would like to base the length of time on the exit d... 16 Dec 2009 16:52

Concatenate By Selection
I'd like to develop a function/macro to use that will allow me to concatenate two or more cells based on the cells I select. As I scroll down in my data, sometimes there are two cells that must be concatenated, but sometimes it is three or more. In the end I am hoping to come up with a simple way to highlight the c... 16 Dec 2009 16:52