Excel Worksheet Functions - Page 16

Thread / Thread Starter	Last Post	Replies	Views
=month() function equivalent for fiscal calendar Jon Ratzel[_2_]	by Jim	1	1,971
=NameCheck - Monday??? Lost Cluster	by T. Valko	3	764
=networkdays formula was working, but not in upgrade to 2003 bakercenter	by bakercenter	2	985
=NETWORKDAYS not working as expected and as it once did USAOz	by Ardus Petus	2	716
=Now() Karen	by Gord Dibben	7	381
=now() Jim	by paul	3	312
=NOW() f16pilot71	by Michael	2	337
=Now() Format GS1976	by Bob Davison	2	468
=NOW() Time Function. I want this to be live! Gareth Evans	by Ragdyer	7	830
=offset ??? myeaddress2003	by tony h	4	353
=OFFSET(!$A$1,,,,) - global range naming Epinn	by RagDyeR	3	588
=OFFSET(cell("address"),-1,0) JJ	by Harlan Grove	6	973
=OR and =IF Help Pam	by Pam	3	417
=OR(IF(AND(....),HYPERLINK.... zx6roo	by Max	3	383
=ppmt Principal loan payments	by Principal loan payments	0	454
=randbetween still produces "#name?" after running the add-In runbball	by Dave F	2	427
=RIGHT (function) Philippe L. Balmanno	by wdk	14	887
=right and =vlookup Marc	by Marc	4	337
=ROUNDUP(INT(0.xxx)) Dave F	by Epinn	7	743
=sheet grahame	by FSt1	1	326
=sign(--counta(range)) not working righ t [email protected]	by JoeU2004	4	450
=SLOPE(OFFSET(INDEX .... Help please Mark K[_2_]	by Bernd P	9	2,427
=substitute Kalop	by Stan Brown	3	585
=SUBSTITUTE(C4,"~?#","") will this work to remove multiple string Raja Mahendiran S	by Raja Mahendiran S[_2_]	6	2,047
=sum gma	by gma	5	349
=SUM question John Smith	by John Smith	6	363
=SUM returns 5.54365E-11 instead of 0 (zero) Chwan Keng Ng	by Stan Brown	6	3,840
=SUM Then insert word. iwgunter	by mzehr	3	942
=sum with a filter CJH	by Claus Busch	2	576
=SUM(($C$1:$C$7=--"10/01/2004")($C$1:$C$7<=--"09/30/2005")(H$1: kathi	by kathi	2	378
=SUM((B7+2),IF($D7>0.Workday,($D7+E$8,Holidays!$C4:$C11$),'''')) Spear	by JE McGimpsey	2	475
=SUM(A1:A5)*24 for totalling hours and minutes is not working Calebs Grandma	by Gary''s Student	2	496
=sum(A:A) add to column (B) and new value repeats w/ new sums planecents	by Bob Phillips	3	662
=SUM(I47:I115) What does the "I" mean and how is it used? Julie Ibarra	by Bernard Liengme	2	536
=SUM(IF help please kristap	by T. Valko	5	455
=SUMIF He4Giv	by Biff	9	465
=sumif function Lim	by Ashish Mathur[_2_]	1	380
=SUMIF Problem doctorjones_md	by doctorjones_md	2	372
=sumif(a1:a3,"median(a1:a3)") always gives 0. What to do? Bill Friedman	by Max	1	472
=SUMIF(B8:B38,"<"&TODAY(),D8+H8+L8+P8+U8+Y8) JR	by JR	2	861
=SUMIF(Input!H2:H718,AZ19,Input!E2:E685)AND(IF ALex	by John Britto	2	667
=SUMPRODUCT LHerring	by Teethless mama	2	406
=SUMPRODUCT Jim	by Aladin Akyurek	9	527
=SUMPRODUCT and =IF Jim	by Jim	3	494
=SUMPRODUCT Col E = B, Col F = blank 77Debbie77	by Dave Peterson	7	516
=SUMPRODUCT formula help Anthony	by Anthony	5	510
=SUMPRODUCT formula is counting the blank cells as well as zero's JR	by Sloth	2	808
=SUMPRODUCT formula is counting the blank cells as well as zero's JR	by	1	649
=sumproduct in Excel 2000 LPS	by LPS	2	673
=SUMPRODUCT not working JR	by Kevin Vaughn	3	485
=SUMPRODUCT((C481:C507<"")/COUNTIF(C481:C507,C481:C507&"")) Jeff	by Eduardo	3	346
=sumproduct((f5:f498=(cp5:cq5))(e5:e498=(cp6:ct6) )(m5:m498)) Ruthki	by Ruthki	2	409
=SUMPRODUCT((Overtime!$J$6:$GY$6-DAY(Overtime!$J$6:$GY$6)+1=A25)*(Overtime!$J$7:$GY $2 paulrm906	by paulrm906	8	709
=SUMPRODUCT(--(('Access Data'!B$1:aaaa)=$A5)) Paul Dennis	by Kevin Vaughn	4	622
=SUMPRODUCT(--(TRIM(A1:A10)<"")), what does the "--" mean? Ray	by T. Valko	2	1,823
=sumproduct(round( mhoffmeier	by T. Valko	3	3,203
=sumshifts adketcham	by adketcham	0	801
=text(a1,"dddd") question Dylan @ UAFC[_2_]	by T. Valko	10	1,216
=TEXT(I21,"MMYY") Thank you, Heath	by Kevin Vaughn	10	751
=TEXT(L9-K9,"h:mm") How can I sum the results to a total value be013fc	by Shane Devenshire[_2_]	4	583
=Text(n,"mmm") always returns "Jan" when n=1..12 Blaze-Of-Glory	by ExcelBanter AI	12	7,588
=today() Kanaski79	by Dave H	8	460
=TODAY() Steved	by Teethless mama	7	448
=today() = weeknumber Derek M[_2_]	by Michael.Tarnowski	3	676
=today()-3/7/2009 = 4? dindigul	by Niek Otten	2	344
=TRANSPOSE: getting 0es but waste cells wanted LevT	by Dave F	2	467
=TRIM and =PROPER in a nested statement? MarvInBoise	by ExcelBanter AI	3	8,863
=VLOOKUP(1,Nationality!B5:B29,IF(MONTH(date)6,MON TH(date)-6, MON Ali	by Ali	14	1,854
=vlookup(A1:A835,"bbb",AI7:AL165,C7:C165) giving #value! ???????? Harvey Tod	by Eduardo	2	655
=WEEKNUM function Roger H	by Stefi	2	479
=weeknum() - installed the add-in Marcotte A	by Marcotte A	2	648
=YEAR(3/7/2007) in EXCEL, get the answer as 1900. Why? LadyCat	by driller	8	975
>> IRR function Jonathan Parminter	by Jonathan Parminter	2	376
? radar	by Stephen Bye	4	438
? ivantang	by Don Guillett	2	443