PDA

View Full Version : Microsoft Excel Worksheet Functions


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 [98] 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160

  1. how to change the default formatting of comments in excel?
  2. Please help. Very simple but I don't know. :)
  3. Locking cells in Microsoft Excel
  4. Re: Formula Help - Easy for somebody
  5. Re: COUNTIF or SUM function (Multiple criteria) HELP!!
  6. Re: COUNTIF or SUM function (Multiple criteria) HELP!!
  7. Tab/Enter key moves to next available cell in protected worksheet
  8. cell change event
  9. 401k formula
  10. Probably easy but I need help!
  11. set up a macro in Excel to color cells when clicked
  12. Copying a Blank Cell
  13. Error in lookup function
  14. question about a basic formula
  15. if formula
  16. how to create constaints in solver
  17. Help with LARGE formula with multiple worksheets
  18. Copying formulas too smart for itself...
  19. How do I formula a percentage with text values in the data field
  20. Calc End Date
  21. using ============
  22. Describe high/low range with CountIf (ex. count if >90 and <100
  23. Describe high/low range with CountIf (ex. count if >90 and <100
  24. Why is data automatically copying to all worksheets?
  25. how do I count a rota with no dates and using 24 hours clock
  26. SUM cells together based on 2 criteria
  27. linking sheets in workbook
  28. Problem with Formula
  29. Pivot table limit
  30. first positive value return date
  31. Can changes to a worksheet be applied to all wksheets in wkbook?
  32. sumproduct
  33. find partial values in cell
  34. macro or function
  35. Autorecovery
  36. This will test you!!
  37. data analysis option not visible
  38. asking again, macro to insert rows
  39. Searching an Alphabetized list for data, then RESORT
  40. How do I enter cell references in "Equal to" box in solver
  41. Drop Down LIsts
  42. vlookup
  43. Multiple functions per cell?
  44. How do you ...
  45. data tables in Excel
  46. Sum Count of Two Numbers in the same Row
  47. Excel Formula please
  48. How to sum items from column A only if Column B row equals X
  49. Inserting rows
  50. Count matching cells
  51. Quick-keys for FILL color?
  52. SUMIF Function Inside SUMPRODUCT Function
  53. cell to show ' 0 ' , or nothing at all, if the sum is a negative number
  54. Text Functions,
  55. Copying formats - column widths, formats, outlining to worksheets
  56. Excel Templet purchase order multiable pages
  57. Compile list of same cell from multiple worksheets
  58. Multiple Substitutes
  59. LOOKUP command
  60. Sum of Range of Cells
  61. What does @SUM mean?
  62. Enable Macros
  63. Exclude certain cells from printing.
  64. Conditional format of minimum number
  65. HYPERLINK IF referencing the cell of the function..
  66. Using MATCH() for an exclusive find?
  67. What does a $ in an excel formula do?
  68. Excel-Master
  69. Date Formula
  70. excel help
  71. COUNTIF - multiple conditions
  72. List of property names and values for a given object.
  73. SUMPRODUCT Acting Quirky
  74. creating and moving hyperlinks - Please help!!!!
  75. Automating Worksheet Names
  76. Return employee name when the employee's number is entered
  77. transfer information from one worksheet to another using a butto.
  78. Vlookup function question
  79. Macro Template File
  80. Custom menu
  81. lookup help
  82. Excel Solver violates constraints
  83. Help With HLOOK
  84. 'CHECK IF A CELL IN EXCEL HAS ANY TEXT IN IT'
  85. VLOOKUP on separate file: Works fine for a while....
  86. A bit of a Stumper
  87. Macro Help - Copying and appending data
  88. Collapsable Rows?
  89. How do I increment a formula?
  90. changing cell colors with formula
  91. Formula to determine whether number falls within range??
  92. Separate address column to Five columns
  93. Permutation in excel
  94. Rational exansion of a decimal number
  95. COUNTIF With Non-Continuous Cells
  96. Time Sheet to show hours owed
  97. Protecting Cells
  98. Permutation in excel
  99. Some help needed
  100. Percentage formula's
  101. Software to create color coded maps from excel?
  102. Finding Duplicates
  103. multiple pivot ranges
  104. need 360-day loan amortization excel spreadsheet template
  105. Rolling Balance after 30 days
  106. Re: Find function
  107. Need date to appear 90 days later than initial date entered
  108. Creating Scenarios and Scenario Manager
  109. freeze content
  110. Validation from Database (not sorted)
  111. How do you update links
  112. filters logics
  113. INDIRECT FUNCTION jams?
  114. Countif function
  115. Find function
  116. use if function to change cell color
  117. create an array with unique items IN MEMORY
  118. dynamic connections in excel?
  119. random combination of letters
  120. Counting with Array Formula
  121. How to find MATCH numbers ?
  122. fill handle + query
  123. Can I get excel to auto save details from a cell into the doc nam.
  124. multiply the value of a cell
  125. How can I get rid this value "#VALUE!" in the cell
  126. Excel formulas
  127. Worksheet terminology
  128. how can i change the row from 123 to ABC
  129. If Then Statement in Excel
  130. Excel, Need some help
  131. Copy and paste from one spreadsheet to another
  132. Vlookup to find Second INstance
  133. blank cells
  134. Max Lookup formula
  135. Need to find 200 students from column of 1000
  136. Format a cell for hours ' minutes "
  137. Can Excel send alerts when due dates are not met?
  138. How to identify entries in a matrix also present in another list
  139. help locating first empty cell in a Column
  140. HOW DO I SELECT ROUND NUMBERS ONLY IN EXCEL SPREADSHEET
  141. Indirect function - Limitations
  142. Please help....
  143. In excel, how can I create a towards column in a single box?
  144. A calendar calculator template that reflects remaing weeks in a ye
  145. Formulas not recalculating when values change on another sheet
  146. Counting number of occurrences
  147. Autofilter - can I increase the drop down font
  148. Cell value & hyperlink
  149. Another IF question
  150. How did excel get de-installed? Got error mssg: CiceroUIWndFrame
  151. I can't delete columns - help!
  152. Macros for the AR Aging Workbook template?
  153. converting number string to number with decimal
  154. Auto populating fields
  155. Re: Help
  156. lookup returns row number-why?
  157. The number of hours in a day cannot exceed 24...
  158. Allow unprotected cells to spell check after sheet is protected
  159. Summing on multiple conditions
  160. Sumproduct question
  161. Re: IF statement
  162. Moving Around a Blank Spreadsheet
  163. IF statement
  164. If Or?
  165. Using Sumif with 2 conditions
  166. Locating Last Nonzero Cell in a Row
  167. Populating several cells
  168. Limits of MINV matrix function
  169. Problems with an IF statement
  170. Ranked list
  171. HELP - Date Range In 1 Cell Calculation
  172. Downloading documents
  173. concatenate strings
  174. How can I use like a mail merge feature in excel to create a form
  175. How do you calculate CAGR In Excel 2003 with no initial cost?
  176. count unique phrases in a word table or spreadsheet
  177. Columns
  178. counting comments
  179. Average based on Hour
  180. Compare Side by Side in Office XP Excel
  181. lookup based on a row number
  182. select lines from multiple worksheets and write to new worksheet
  183. Hiding a row if date is filled
  184. Help to adapt Formula syntax to work with Visible Filtered Cells
  185. How generate trendline equations for Power, Exp and Log trendlines
  186. how to get rid of #N/A
  187. combining data
  188. Conditional Formatting
  189. Date Creation in Cell
  190. COUNTIF or not to COUNTIF on a range in another sheet
  191. how could I import a text file with comma separated values into ex
  192. how to use input formula from several worksheets in excel?
  193. combining 2 pieces of text from 2 columns
  194. Formula error in merged cells
  195. data validation list should have opt. to select based on criteria
  196. Print only cells with values
  197. Linkage data between two spreadsheet
  198. How do you add a-z (alphabetically) to your toolbar in micr works
  199. Make boxes apear on paper?
  200. output based on data in a graph
  201. Page Header
  202. Search feature in workbook
  203. Getting the first 3 digits out of 6 digit cells?
  204. Can't get list in Document Contents for workwheet
  205. drop-down list validation won't allow a different worksheet
  206. options under tools dose not come up
  207. Formula Assistance Required
  208. How do I define "contains' as the default custom filter?
  209. how do i get this
  210. Finding DUplicate Data set in Worksheets
  211. Locking a table
  212. Formula to determine number of Standard Deviations based on % of population
  213. Opening multiple Excel files that contain varied selected sheets
  214. What is wrong on the fomular: Offset(MIN(A1:A10),,-1)?
  215. Sales League table
  216. Comparing Two Spreadsheets
  217. Locking cells after one answer
  218. Re: Help with formula please...
  219. Help with formula
  220. calculating number of months from today
  221. countif
  222. Date functions
  223. how do I keep the dropdown list button visible continuously
  224. Excel 2003 Subtotals not working correctly
  225. Using countif with 2 conditions
  226. Can I use Excel to create this text file?
  227. Locking format
  228. ranking
  229. Re: Help with formula please...
  230. Re: Couple of hopefully easy questions
  231. Value of a Cell by Time
  232. Forecasting weekday occupancy between two years
  233. matching numbers in col a and col b
  234. Preceding a number by zeros, that is still a number
  235. using linest to generate 3rd order polynomial coefficients
  236. looping through a set of calculations
  237. I cannot convert using HEX2DEC formula? i need a plug in i think?
  238. Calculating Month Average Exch Rate from Exchange Rates Calendar!!!
  239. Adding Cells
  240. drop_down_box
  241. What is the shortcut key for adding $ to a cell reference eg $c$3
  242. =max(range includes #N/As)
  243. Changing positive figures to minus figures
  244. Optimizing mortage payback
  245. How do I get it to insert addresses instead of Next Record?
  246. When I move a vertical border it deletes horizontal borders
  247. add a column only if 5 other cells on the row satisfy criteria
  248. Vlookup Headache
  249. search value in a table and sum another column
  250. one formula to make a multiplication table work
  251. having a two tables on the same page with different widths
  252. Filtering Columns to Align Matching Data
  253. How do I count a value if another field = a specific value? Excel
  254. tab scrolling buttons not responding
  255. tab scrolling buttons
  256. Very Frustrating - Please Help!
  257. Converting CSV files into Excel files
  258. I Need Help with complex formula ?
  259. Avoiding #NUM!
  260. freeze other columns when columns have been frozen already
  261. dynamic defined ranges
  262. Vlookup for data contained in a cell
  263. Excel chart problem
  264. mixed font styles in the output of a formula?
  265. Sorting Identical Data set in a work sheet
  266. Need to compare 2 tables to generate 3rd table
  267. Need to get rid of blank rows without sort
  268. Need help summing time
  269. Cell references
  270. HELP ASAP get rid of blank rows without sort
  271. RE: Cell references
  272. formatting dates
  273. Creation of a Generic Macro
  274. RE: Cell references
  275. RE: Excel chart problem
  276. Please Help and Thank you!
  277. Matching data using date criteria...
  278. finding name within range
  279. Re: Conditionl Format
  280. Re: Conditionl Format
  281. Word Associated Shading or Color
  282. numbers
  283. Calculating two numbers in one cell
  284. vlookup over 2 sheets?
  285. Dates Not Formatting as Dates
  286. lookup cell content in multiple files
  287. Retuning a column number for a specific value
  288. trouble shoot pointing to a cell
  289. How do I change where Excel looks for templates?
  290. tab scrolling buttons - excel 2003
  291. is there a "distinct" function native to Excel
  292. Can excel sort entire rows of data like access?
  293. Lookup question.
  294. Help One Way did not work
  295. SHORT CUT KEY(S) TO SHOW OR HIDE SEETS IN EXCEL
  296. Conditional Formatting that will display conditional data
  297. formula change
  298. Multiple If Statements
  299. Adding numbers in a single cell
  300. HOURS DIFFERENCE IN TIME BETWEEN DIFFERENT DATES AND TIMES
  301. Look up problem
  302. European date formats
  303. Comparing ranges and deleting
  304. extract data Column 1 starting with A1, A4, A7, A10, etc.
  305. Macro
  306. *HELP NOW PLEASE*
  307. How do I split a cell of 2 words into two cells
  308. Re: Count &quot;how many in a row&quot;
  309. how do i find # hrs & mins. between 2 different dates and times
  310. Contains instead of Equal
  311. Help Needed Urgently
  312. Connect columns, with restrictions
  313. Count &quot;how many in a row&quot;
  314. Re: Count &quot;how many in a row&quot;
  315. Adding time Values up in Excel
  316. format column for unique values only
  317. move from one column to another after a set condition
  318. How do I stop Excel from treating blank cells as zero?
  319. Make a formula that adds every 4th cell in a column indefinately?
  320. Copy and paste from 1 workbook to another
  321. Display "Last updated date" for the Workbook (without using a macr
  322. What is the spreadsheet function in excel
  323. Non-random numbers generated by excel's data analysis random gener
  324. Counting cells
  325. Subtotal results without word "Total"
  326. how do i calculate time in & out in excel using a formula
  327. Frequency of values with Criteria
  328. If typed 12805 then 12/8/05
  329. link help
  330. How do I sort entire spread sheet. Names w/data
  331. linked cell is displaying formula instead of the data
  332. Your online office "help" system REALLY sucks!! I'm not kidding!!
  333. vlookup almost does this but not completely...
  334. Delete repeated Cells
  335. #Value error when linking workbooks
  336. 2 different Companys. Data Sort
  337. Information from column to row
  338. finding if name within range
  339. Contents of cell
  340. error N/A
  341. Lookup
  342. organizing a workbook
  343. using getpivotdata function
  344. vlookup reverts to data from a previous report
  345. Functions not "recalculating" when input changes ???
  346. Merge & Center function is turned off...how do I turn it back on?
  347. using a checkbox for a conditional function
  348. Copy Cell Referecnces
  349. Text from Max value
  350. How do I randomize ascending data (number values) in excel?
  351. I want to add automaticaly my postponed check in my banking regis.
  352. Multiple coin flips in a single cell
  353. Sumproduct not working when summing values between two numbers
  354. Prevent Worksheet Deletions
  355. Pivot Table - 'Merge Labels' option and formatting
  356. Reformat IF(ISERROR(....) : if 1st option returns empty, look at 2nd option.
  357. Shared files
  358. How do I reconcile bank statements?
  359. How many std deviations is Excel function "STDEVP"
  360. Locate and retrivie data in table/matrix
  361. attendance sheet
  362. Frequency within date range
  363. File won't open. Error message "too many different cell formats"
  364. Pulling data from another workbook
  365. Format single column cells to be 6 characters long
  366. Pivot Table Question
  367. Use functions when cells are merged
  368. Select one of many clipboard item to paste into document
  369. using filters with the sum function
  370. how to format only a specific character or number in each cell withina range of cells
  371. Delete Rows where cells does not meet criteria
  372. How do I quickly fill a formula result into a column of cells?
  373. printing problems
  374. DATEIF Name error
  375. Arrays
  376. can you filter more than two items in excel 2000
  377. Workbook & multiple spreadsheets
  378. Pivot tables and total count
  379. =CONCATENATE() help!
  380. conditional formatting autoshapes
  381. Help with Formulas
  382. NOT UNDERSTANDING THE FORMULA
  383. Fill handle formula
  384. Pivot tables - calculated fields
  385. Trying to freeze panes. line down and through middle of worksheet.
  386. Showing Garbagge in my File.
  387. Interpolation using GROWTH function?
  388. Fill down to nonblank rows
  389. creating function (vba) with range arguments
  390. Protection-exceptions to delete a row
  391. Copy & Paste macro
  392. Summing specific cells!
  393. Subtraction formula for consecutive cells in a column, skipping blanks
  394. Auto number invoices in Excel
  395. XIRR function not defined?
  396. Excel sheet question
  397. 1430 to 2:30pm
  398. SUMIF problem...
  399. Average Function Help Needed
  400. =(A6)!$O$14 - why won't this look for same name sheet as A6?
  401. Summing accross sheets
  402. is there a percent error function in excel?
  403. removing year from date
  404. Put comments on a locked spreadsheet even though cells not locked
  405. if function
  406. Splitting Character String
  407. Remove apostrophe
  408. Need help with formulas
  409. Dro pdown list formulas
  410. halves
  411. Excel formula for monthly interest rates
  412. Referencing worksheets
  413. Smart tags for financial symbols
  414. Re: If
  415. Re: If
  416. Re: If
  417. How do I create a weekly series?
  418. Compare two lists with two variables
  419. return a cell contents as the result of usiing "small"
  420. if statement problem
  421. Need Help Writing a Formula
  422. Delete repeated numbers in Excel
  423. delete repeated numbers
  424. comparing two columns & then perform a calculation
  425. Sort from lowest to highest
  426. Excel should have a tan^-1 Cos^-1 and sin^-1
  427. display minutes and seconds in excel
  428. Re: ifsum slows down calculations
  429. How can I count values greater than and less than certain values?
  430. Apply cell shading based on adjacent cells in EXCEL
  431. EXCEL: IF CELL B6 RED, HOW DO I GET A "W" (ie for win)to show up
  432. serial number cell
  433. Find and Concatenate
  434. Range of data within a column
  435. Another Nesting IF Statement Problem
  436. Pivot table grouping of dates in row fields will not work. Why?
  437. Formula Help with Lists
  438. nesting if statements
  439. Summing only those cells that aren't hidden
  440. Random Numbers
  441. preserve "-" when importing text field from access
  442. SUMIF excel function not working
  443. How do you convert embedded drop-down lists in Excel '97?
  444. How to replace a word with a word from other column?
  445. counting unique values and matching to quantities
  446. What formula would I use to get -2 / -2 = -100%
  447. linear interpolation function in excel
  448. How to record macro to print pages modified today
  449. Controlling text in an Excel worksheet
  450. Concatenate and Vlookup
  451. Don't know what to call what I need?
  452. Re: can you entre a bar code into a excel cell?
  453. Help with conditional format
  454. Type in letter return word
  455. Please assist
  456. Linking cells
  457. Function
  458. Count cells with condition
  459. Is it possible to put 2 splits on one page? If so... How?
  460. Using dates in formulas
  461. My DCOUNTA formula results do not display in Excel.
  462. keep date format in a Combo box
  463. Fill-in empty cells from SAP report
  464. automatically insert row at each page break
  465. Conditional Average
  466. VBA Custom function for lookup
  467. % change in the last two cells in a row
  468. 27 sets of data. Need to find zero in each set
  469. Help writing an Excel Formula
  470. converting a number to English text ( not to Baht) is needed
  471. Count the number of Cells in one ROW with conditions
  472. How Show decimal in Bar Function
  473. How to pluck out initials of a 2 or 3 word name
  474. Count occurances Problem
  475. Div/0 error
  476. NOT UNDERSTANDING THE FORMULA
  477. return left most part of cell
  478. Index question
  479. Excel should let me sort by colour
  480. How can I get excel to look up prices in a table
  481. Conditional Formatting Reference / Inserting Rows
  482. special sum formula
  483. Evaluating Rank to determine formula
  484. commission spreadsheet
  485. IF Function??
  486. Evaluating results of a concatenate formula, as a formula
  487. Sumproduct.................
  488. Determining a specific time during the day
  489. Regression Statistics are returned as Rounded to 1 vs. several dec
  490. Close excel do not save
  491. Check box, then add current time to cell
  492. text function
  493. How do I calculate a future date in excel?
  494. delete spaces
  495. Using offset more than once on the same sheet
  496. format social security number
  497. Counting occurences of a substring in a range of cells.
  498. Complicated formula
  499. Compare two different size lists
  500. if function multiple variables
  501. Unhiding multiple worksheets in Excel 2000
  502. cut and paste subtotal from excel
  503. creating a excel spread sheet using ffinancial functions
  504. Looking for experience with counting and conditions in excel 2003
  505. Re: Using COUNTIF for Counting Words?
  506. countif OR function
  507. VBA function for "Mean" using Array as argument
  508. How do you sum just values that are bold in a list of values?
  509. separate text into different cells
  510. Refer new sheet to previous sheet
  511. How do I select on two variables in a range of data in excel
  512. FITTING HEADER ON SECOND PAGE TO PRINT
  513. how to return mulitple corresponding values
  514. Warning - "Fixed objects will move"
  515. Repeat calculations
  516. Fair Play
  517. Calculation of full hours
  518. Function for decreasing salary by 2.5%
  519. Count cells with specific values in the cells next to them?
  520. How can we see two different excel sheets on one screen?
  521. Can a UDF be used on an array of cells?
  522. Help with a Date Formula
  523. calculate payment with first payment due date variable?
  524. Counting .5 in a pivot table
  525. Count or result of matching cells
  526. Experienced any problems with nested subtotals using Windows XP
  527. List box, copy multiple Cells
  528. Moveing Data to another Worksheet
  529. How do I prevent a formula element from incrementing when copying
  530. How to highlight an Excel row by clicking on a cell
  531. Select different source data for a PivotTable
  532. How do I prompt a user to update a cell value (ie the date)?
  533. return cell reference from any column
  534. ... Count, <<< Positive Values minus Negative Values >>> ...
  535. Filtering data and replace on to an new worksheet
  536. networkdays
  537. Formulas not updating until save
  538. countif - Criterion1 OR [Criterion2 AND Criterion3]
  539. Format of CSV File in export
  540. Macro help!
  541. Weeknum & Year
  542. Insert manual line break in formula
  543. Extract each item in the list
  544. Any function for Crop/Cut Text
  545. Percent of total in Pivot tables
  546. INDEX and workbooks
  547. VLOOKUP in SUMPRODUCT array
  548. #Name? Error when using NETWORKDAYS function ......
  549. Colour (color) problems
  550. Vlookup
  551. Counting Occurrence of Text within Text in Cells in Range.
  552. How do I convert a given number into a letter?
  553. What do I need to do here please.
  554. problems with macros
  555. Asking for Formula ~ Thanks!
  556. Verifying Dates
  557. Translate WEEKNUM result into a date
  558. Getting Yahoo Stock Quotes by a USer Defined Function
  559. MODE isn't working properly.
  560. Financial Calculation Help Needed -- Annunity
  561. combine the two into a single formula please
  562. Sumproduct + Array Function?
  563. Help on Networkdays
  564. ok for the first but I would like the first 2 Left please.
  565. ok for the first but I would like the first 2 Left please.
  566. ok for the first but I would like the first 2 Left please.
  567. Excel 2000 to 2003 update links doesn't work properly any suggest
  568. How can i italicize a word via a formula?
  569. Count Occurances if two conditions true
  570. Convert Range name in cell for VLookup
  571. VLookup returns #VALUE!
  572. RE: Track changes across multiple worksheets
  573. Need Help: 'sheets' function with a variable in a formula
  574. countif >0, specific cells
  575. finding the right number
  576. Linking Columns and cells
  577. Problem with a "if" "then" situation.
  578. formula for finding a value!
  579. dates and if statement work on one sheet, not on another
  580. How do I use space provided for Company information
  581. How do I get custom views created in Excel 2K to show in Excel 200
  582. Dynamic Time Display
  583. Countif not blank
  584. Need help with lookup on text format
  585. ActiveX works in my spreadsheet but when sent to others, doesn't
  586. Counting cells that meet 2 differnet criteria
  587. Functions not "recalculating" when input changes ???
  588. Formula for rounding to the nearst eighth of one percent
  589. Excel Font Effects should include Upper Case
  590. Re: function for finding a value!
  591. Sorting by text colour
  592. Excel: Format Control: 'cell link' reamins constant. How to copy
  593. Creating Macro or Code Help?
  594. Sunrise / Sunset
  595. Import Data
  596. Formatting cells is not retained when saved as csv file
  597. Need assistance with printing macro
  598. Sorting Data
  599. Can we have custom Column headers instead of default
  600. Annual interest rate
  601. running balance in excel
  602. How do I find a name in a list of names?
  603. How can I get the domain name out a email adress?
  604. what is the formula to change 08/14/51 into 1951?
  605. Count occurances in range of cells
  606. How do I use VLOOKUP to find values across more than 1 sheet or Wo
  607. How do I keep with column widths of a pivot table when I refresh
  608. VLookup on two criteria - Not two dimensional
  609. excel function help
  610. sum using reference from other worksheet
  611. Lookup function, need help
  612. Automated file name retrieval and updates
  613. Analysis ToolPak Translator
  614. in a line of three possible answers how to prevent multiple answer
  615. excel files into money 2005
  616. How do I retrieve a date in a column of dates which > my criteria
  617. Return to individual sheets
  618. Linking total amounts
  619. sum and variable rows
  620. Disabling protected cell selection
  621. Formula which is greater tahn or equal to zero
  622. Create a single sheet from many sheets
  623. Comparing dates
  624. Can a conditional formula indicate "date added" next to a text?
  625. Vlookup Calculation Issue
  626. Cenvert dollar amount into words
  627. no formula results in cell
  628. I need a template for my supply inventory
  629. Auto convert an alphanumeric string (CIS9638S) to numbers only?
  630. RE: Auto convert an alphanumeric string (CIS9638S) to numbers only?
  631. Arithmetical Mode Value for Filtered cells in Multiple Adjacent columns
  632. If column c # is 101..then column e is $14.32 & column g is $8.00
  633. How do I calculate and show negative time in Excel?
  634. RE: Auto convert an alphanumeric string (CIS9638S) to numbers only?
  635. roundup within a formula
  636. RE: roundup within a formula
  637. i need help with a calculation formula...
  638. Sort with a List
  639. Excel 2003 - Copy Cell Reference
  640. Multiple Item Replace???
  641. How do I show negative number in brackets using excel?
  642. Add money to a sum
  643. Data Entry
  644. How to add equal values and than replace them with their sum?
  645. Formula with current Date
  646. Re: Date format
  647. Copy a cell value and add literals
  648. Multi - Level Question involving Data Mapping and Formulation
  649. Identifying Dups in different ranges
  650. Count IF problem
  651. Need to find a row in a worksheet based on the value of a cell
  652. Statistical functions query
  653. Function to ignore decimals
  654. Creating Worksheet Using Server Object
  655. If statements
  656. Transposing Data
  657. Creating Worksheet using Server Object
  658. I want to make three sub colums under an original colum
  659. How do I copy a function with a called cell constant?
  660. SUMIF FUNCTION?
  661. VLOOKUP for Zip Code Ranges
  662. Formula
  663. Is the IRR calculation based on cash flows at beginning of year?
  664. Conditional Formatting
  665. Can I show a formula's result on a worksheet tab?
  666. Ladder Help
  667. change case in excel
  668. Using boolean function for color fill
  669. Re: Truncating text before a hyphen
  670. Truncating text before a hyphen
  671. Formulas and worksheet linking
  672. IF Command conditional formating
  673. find position of a number in a string
  674. League Tables
  675. What Function to use?
  676. Require alpha-numeric entry
  677. How to share a workbook to our staffs
  678. Solution Required to prevent #Ref! when rows deleted
  679. Re: Function or number depending on input
  680. Discount rate - what to use?
  681. Filtrera Pivottabell
  682. IF formula?
  683. Calculate Date range
  684. Adding and Naming Multiple Worksheets
  685. Subtracting a Countif result from a constant
  686. Multiple Regression in Excel 2002 SP3 (Office XP)?
  687. Cell Separation
  688. Separate Column Sorting
  689. how to convert numeric into alphabet
  690. to convert Minutes into Day:Hr:min (not as fraction)
  691. box formatting
  692. how to add or subtract from two cells into one
  693. Returning the formula in another cell
  694. Exporting multiple cell contents into word document
  695. Box-Jenkins techniques & Time Series
  696. Formula to duplicate data to second sheet
  697. How can we get more columns on a spreadsheet, like 365 days/colmn
  698. I only want to print the horizontal lines in a spreadsheet
  699. conditional sum formula
  700. Re: Change to formulae
  701. Re: using text as a cell ref
  702. Option Button Help
  703. Solver, macros Excel
  704. How do I protect only formulas(functions) in a workbook?
  705. Format of one cell conditional on another
  706. Excel worksheets
  707. First part of "IF" function returns false even if true. ??
  708. Check for double entries in a row
  709. Re: Help with a Ladder
  710. Re: calculate numbers based on font color?
  711. How to change a series of positive numbers to negative numbers
  712. Sum function based on format
  713. RE: date function
  714. Re: date function
  715. Conditional sum
  716. Counting a Filtered Dataset
  717. Re: How many users can sucessfully use a shared excel workbook?
  718. Re: Colomn of strings, how to count each string with "abc" OR "def"
  719. Re: Trying to pull date from field getting error.
  720. Re: Function or number depending on input
  721. Re: Conditional Formatting
  722. spellnumber function
  723. I NEED A FUNCTION TO FIND IF THERE IS AN INTERSECTION BETWEEN 2 DATE RANGES
  724. Pls Help!
  725. Asking for formula~thanks!
  726. Increase figures in cells by a percentage (on entire workbook)
  727. average of kth largest numbers in an array of n numbers
  728. formula's in cells are not calculating
  729. how do i create range names ?
  730. Coloring certain cells
  731. Nested "if" not returning expected value
  732. Excel Idiot Needs Formula Help!!
  733. How to get the complete list Excel Worksheet Functions
  734. Complicated Index Match Offset function
  735. Hide #DIV/0!
  736. HOW DO WE SET A FORMULA TO FIGURE A YEAR TO DATE TOTAL ??
  737. HOW DO WE SET A FORMULA TO FIGURE A YEAR TO DATE TOTAL ??
  738. Using Name as Worksheet Reference
  739. How can I have excel sort through a data string of dates?
  740. Formula problem
  741. HELP-Can not type on Spreadsheet
  742. I cannot change spreadsheet to rewritable
  743. Carrying formatting automatically to new W/S
  744. Need help with Vlookup
  745. FORMULA BAR OF SPREAD SHEET
  746. Different results from AVG funtion
  747. Novice Needs Help with Formulas
  748. References and links.
  749. monthly total
  750. adding formula to existing database