Excel Worksheet Functions - Page 633

Thread / Thread Starter	Last Post	Replies	Views
How can I use €œcountif€ to count BOTH zeros AND blank cells as zer Danielle	by JMB	1	585
Copy - Paste Special problem Bob Smith	by Bob Smith	2	511
Mapping values from an index!!?? HELP! BCBS_exceller	by JMB	3	478
How do I build a Construction Schedule of Values in Excel? Caleb Howze	by Martin Fishlock	1	5,719
How can I add times, i.e., 1:45:30 + 2:10:20? wahjazz	by Fred Smith	2	346
EXCEL: MOD FUNCTION or DIVISION NAIMA	by Max	6	1,461
Calculating overlapping time periods Arlette	by Arlette	0	718
Array formula referencing other worksheets broderp	by Dave F	1	514
Ignore Data for Dynamic Range Dale	by Dale	1	506
Counting Question rlee1999	by Duke Carey	7	446
sumproduct RGlade	by RGlade	3	378
macro or if statement CHARI	by CHARI	2	564
Multiple SUMIF Krish	by Don Guillett	1	355
Counting Words In Excel Formula dayd	by John Bundy	1	393
matrix multiplication for labor costs [email protected]	by [email protected]	0	804
To project inventory rundown and forecast Bob	by John Bundy	1	1,246
Row numbers containing specific value within a column carl43m	by Ron Coderre	15	967
Totaling contributions Jack Taylor	by John Bundy	1	430
how do I remove both duplicate records in excel Mtgdbsmgr	by Duke Carey	1	514
yield of a security Securities Auditor	by Duke Carey	1	566
need help creating formula [email protected]	by [email protected]	2	447
converting text to number Julio	by John Bundy	1	413
Return Column sign - PLEASE HELP Nir	by Roger Govier	1	409
finding one value by combining many Trandall37	by Bernie Deitrick	1	368
Counting Marked Cells Fred Atkinson	by Fred Atkinson	3	1,494
Create a funktion Jenna	by Jenna	2	450
Copying Excel formulas between sheets Hoz	by frankjh19701	2	1,156
How to find and replace all "*" symbols Roger	by Ron Coderre	3	759
Error message: "cannot shift object off sheet" Peter Vickers	by Dave Peterson	4	1,304
Don't know what to call the type of function I need Kasey	by Kasey	4	719
Macro Formula for Max value El Bee	by Gary''s Student	4	811
VLOOKUP steph44haf	by Alicia	6	443
PMT Function Ashley	by Bernie Deitrick	2	385
combo reference on another combo box for picking address etc. kbjin	by Ron Coderre	1	1,022
Date function Pasty	by Pasty	4	400
Advanced IF statement / LOOKUP Jane	by Jane	4	600
Conditional Formatting Green-shutters	by Bob Phillips	2	300
dates Susie	by Dave F	1	303
Calculate the number of days between two dates,missing weekends? littlejess22	by Dave F	2	1,397
LEADING ZEROS IN FORMULA RESULT Advent	by Advent	4	887
variable text value within string formula required to sum column Tester	by CLR	2	662
Creating a formula JMP	by Nick Hodge	2	431
Numbers Converted to Text - Last Digit Replaced by Zero Cheryl B.	by Ron Rosenfeld	18	2,405
help in formatting cells [email protected]	by Bob Phillips	1	362
convert second to date and time --== Alain ==--	by Bob Phillips	4	775
Cannot enter 0% into a cell Louise	by Louise	3	526
merging info from different tabs Ted	by Ted	0	517
Counting values with IF value? wester69	by Wester	5	440
count cells using multiple criteria kjguillermo	by T. Valko	1	603
how to convert numbers into words jigesh	by Paul B	1	851
Concatonate - can it be undone rita	by rita	3	383
Reading a worksheet from a specified workbook [email protected]	by Dave Peterson	1	462
Copying Conditional Formatting formulas pwsok	by Otto Moehrbach	1	924
Multiplication Danny Mac	by Danny Mac	8	642
Sumproduct ... Maybe? Ken	by Ken	5	518
Quickly moving rows of 5-column groups on 1 continuous line C.O.	by T. Valko	2	700
Turning rows of equal number of columns into 1 continuous row chimerical	by jlepack	1	679
How do I keep leading ZIPcode zeros from disappearing in Excel? Krabapple	by Gord Dibben	2	3,008
Opening Excel file on a specific worksheet sdhaight	by Dave Peterson	7	789
Calculating Time Karen	by bj	2	516
Does SQL.REQUEST not work for PostgreSQL? wc_marcos	by wc_marcos	0	518
count number of occurences on a particular date [email protected]	by jlepack	4	723
"#N/A" -- can I convert to a "0" (zero)? Branchie	by Gord Dibben	2	631
Trying to restore all default settings Aria Etriano	by Gord Dibben	1	1,629
Time in Minutes Karen	by David Biddulph	17	965
Excel Macros Kelvin9811	by Gary''s Student	1	358
%1 appears in "Application used to perform action" when trying to edit a file type [email protected]	by Ron Rosenfeld	3	2,469
Auto enter date when data in enter in another cell Brian	by Gord Dibben	5	1,797
VLookUp to extract data MD ENGINEER	by T. Valko	3	1,000
How can I make categories out of my data? NoviceinEXCEL	by Don Guillett	3	584
Adding error suppression to AVERAGE FUNCTION plb2862	by plb2862	3	740
change a string of numbers in to number format Debi	by Elkar	1	582
Changing to excel 2007 dpal	by dpal	2	698
Formula help with ordering quantity Angela	by Angela	8	1,499
I have 100 excel sheets how can I merge all data into one sheet Po	by Ron de Bruin	1	874