Excel Worksheet Functions - Page 1139

Thread / Thread Starter	Last Post	Replies	Views
Comparing Spreadsheets HankHarris	by Frank Kabel	1	857
Populate a field with just workdays Arlen	by [email protected]	3	582
Excel 2003 Recorder Andrew	by Frank Kabel	1	453
How to insert a complex formula in a cell with VBA mircea	by mircea	6	1,474
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? Markus Obermayer	by Peo Sjoblom	1	1,676
Help / Recommendation Pat J Maine	by Pat J Maine	3	565
Find/Replace carriage return & line feed characters in Excel. Mary Cullen	by Peo Sjoblom	1	2,865
Pivot Tables, can I use an external list to select data items? Brian Lofquist	by Brian Lofquist	0	1,196
If and Dates Clarification wal50	by wal50	4	542
Subtracting Negative Numbers Carole O	by Carole O	2	975
replacing just the sheet names within formulas Jeanne Criez	by Frank Kabel	1	800
using OR with IF function? Ron	by Frank Kabel	6	320
Link 2 sheets bruno borgata	by Frank Kabel	1	484
formula for decimal Jen	by Gord Dibben	2	841
IF #N/A RFJ	by JE McGimpsey	4	506
Adding NonBlank Cells Emily8	by [email protected]	3	568
look help jdengel	by jdengel	0	367
Comparing data in two columns and highlighting the data David Kinsley	by Bernie Deitrick	6	1,369
Lock formula?? L/P	by L/P	2	710
sum of a cell if 2 cells meet a condition Markitos	by Markitos	4	736
Leading Zeros in Numeric Values DBavirsha	by DBavirsha	6	1,182
Sum Product Help Needed Edgar Thoemmes	by JE McGimpsey	1	478
Notifications in Excel? cpme	by Don Guillett	4	486
Expired Date Formula Donna in Elkin, NC	by Donna in Elkin, NC	3	1,407
Function within a TEXT FORMULA SteveFil	by SteveFil	2	801
product sum per month per customer Pete Petersen	by Pete Petersen	2	2,060
Tab Arrangement wizard Sridhar Rao	by Frank Kabel	1	518
Conditional sum PO	by Peo Sjoblom	1	399
countif number of occurences per month per year. Pete Petersen	by Pete Petersen	2	1,444
CountIF or SUM Steve Kay	by JE McGimpsey	1	353
file-workbook MATLOCKTRANS	by Bernie Deitrick	1	338
Incorrect SUM Values in Excel Spreadsheets Julie Watson	by Jerry W. Lewis	2	722
data sort by highlighted or coloured cell aplex	by Frank Kabel	2	815
How do you print all worksheets in a file without opening the fil. timmtamm	by Ron de Bruin	1	887
SUMPRODUCT Gerrym	by Gerrym	1	548
sum of date ranges Tanya	by Biff	1	508
Multiple worksheets, multiple workbooks peter marsh	by cds	1	796
Is there a template that calculates inventory totals? rcyphert	by cds	1	1,110
Values w/conditional formatting Fred Timmons	by Bob Phillips	7	1,084
How can I create consecutivlely numbered tickets? wheresleo	by Dave Peterson	1	560
IIF IS NULL Problem scott	by JE McGimpsey	6	899
Calculate date Anthony	by Fred Smith	1	668
How to protect Option button in worksheet Julie	by Julie	2	1,444
HELP WITH FORMULAS HONEYPIE	by Juco	2	376
colum B=average of last 10 values in A gunther	by Lorence	3	400
X IN A CELL TO CALCULATE A FORMULA JUSTIN	by Aladin Akyurek	1	916
help with cell formula Juco	by Juco	3	360
Strikethrough on Excel. How? Jerry Baritone	by Ken Wright	1	1,055
exel Micha	by Peo Sjoblom	2	505
invoice numbering Mel	by Ron de Bruin	2	560
Searching a cell for a certain character. Matt	by Dave R.	3	1,225
Adding drop down menus to a spreadsheet angiejoe	by Debra Dalgleish	1	724
calcuate sales by date and segments Pete Petersen	by Pete Petersen	2	726
lookup, index, match, offset, etc. [email protected]	by [email protected]	2	1,060
Formatting dates in a formula KimberlyC	by Chip Pearson	1	686
calculating service dates Tanya	by Peo Sjoblom	2	1,219
Sm Product a Calendar Month Range? John	by Peo Sjoblom	3	763
Compare Question nick	by Dave R.	1	516
Formula to find information between 2 dates Porous Metals Limited	by George Nicholson	2	854
Using one number to refrence another pugsly8422	by Myrna Larson	4	426
Modifyiing a SumIF Formula to look for "OLA* carl	by Myrna Larson	4	668
how do I round up? Martushka	by Frank Kabel	1	512
Random Numbers Not Equal to Joe Blow	by Gord Dibben	3	921
How can I copy column sums to another spreadsheets as numbers auntpat	by Gord Dibben	3	792
Forms & Emails FrontPage: Forms?	by FrontPage: Forms?	0	373
Combining IF and multiple SUMIF statements, if A>0 & B is between Lee	by Aladin Akyurek	1	1,101
How do I pick a number from a list in Excel? pugsly8422	by pugsly8422	4	1,825
Repost -calculate % change for each phrase. Gwen	by Gwen	0	550
Tools/Compare and Merge Workbooks - Excel 2003 Pro Laura	by Peo Sjoblom	1	1,875
How do I get an excel worksheet to autoclear promisman	by Bernie Deitrick	1	395
If funtion wildcard unodemad	by Peo Sjoblom	2	425
SUMIF between 2 amounts, eg 51>x> -51 sam158963	by Harlan Grove	3	503
cell value as a worksheet reference Stepney_Clint	by Stepney_Clint	2	557
tools options greyed out Glen Brittle	by Glen Brittle	0	860
Two cell accumulator Bill	by Bernie Deitrick	1	439