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. Need of Excel Formula
  2. Copy Sum formulat to another row
  3. LookUp on a Pivot table
  4. combine countif and sumproduct?
  5. Info from one cell making other cells active
  6. COUNTIF across multiple sheets with unknown names
  7. Macro Help
  8. Page break when data changes....
  9. data transfer
  10. Vlookup in another sheet?
  11. Calculate how much time falls between set start and stop times
  12. Formula Problem
  13. time stamp
  14. excel 2007 - adding dollar amounts
  15. Hold restore down
  16. converting hour values to day mean values
  17. linking a worksheet by a cell reference
  18. make chart from dates in a column
  19. counting the last 3 values not equal to x in a list
  20. Simple COUNTIF problem
  21. Function help
  22. table with a runing clock
  23. DATE COMPUTATIONS
  24. Can we have column level authentication in office 2007 ?
  25. INDIRECT with raltive name(s)
  26. AVERAGEIF and group??
  27. How do I perform a different formula on the same cell range?
  28. Is there any way to get an excel formula to display a picture?
  29. embedding a Word Document into Excel
  30. calculating product of 2 cells where 1 cell is in percentage
  31. Using Validation I think???
  32. Date formats and computations -- Help
  33. Can Conditional Formatting do this?
  34. formula to color fill a cell if number over assigned value
  35. =+(NUMBER OF CELL) IN A CELL, WHAT DOES IT MEAN?example =+D101
  36. Formatting Problem: Circular Reasoning
  37. Shot down with blanks
  38. Exclude dates from a sum formula
  39. How does Excel calculate Multiple R when doing multiple regression
  40. How to get a blank cell instead of a "0"
  41. age function
  42. how to specify a range that is variable.
  43. Finding the previous Saturday, then Friday date
  44. OR
  45. How to convert 243 seconds to 4:03 (mm:ss)
  46. format cells from data range
  47. Solving the 'CLUE' Murder
  48. IF scenarios
  49. Proper function for task.
  50. Unique Lists
  51. Subtotal
  52. protected sheet cursor movement
  53. sheet protection
  54. How do I return "leave cell blank" using IF logic.
  55. Nesting function or other suggestions
  56. Excel sheet -office 97
  57. Merging Multiple Records into One Ro
  58. Need suggestion on best "lookup" function to use
  59. Does Xcel 2000 have a list function like that in 2003
  60. VLOOKUP Problem
  61. Highlight Duplicates, Macro?
  62. SUM UP DIFFERENT CURRENCIES
  63. Creating a Master List from sub-lists
  64. Linking Sheets On Network Shares
  65. Macro Help
  66. need help with a formula in excel 2003
  67. Multiple lists and vlookup
  68. Macro to get file off the internet
  69. Vlookup and ranges
  70. formula to id a non-standard tick
  71. Put A Space Between 2 right characters
  72. Excel2000:How to link Print Area with a named range
  73. Blank cells, or not.
  74. More help with Formula
  75. change colour of font when below 94% automatically
  76. Matching specifc dates using Conditonal format
  77. Edit Range of a protected worksheet
  78. How do I format cells to show part of a postcode?
  79. Standard index form - Generating leading number (before *10^x part
  80. Average question
  81. How to paste across 20 worksheets within one workbook
  82. shortcut for increasing or decreasing the number of decimals
  83. Dividing zero by zero
  84. how to count number of pages in worksheet
  85. linking a fixed cell
  86. Dynamic Range
  87. if worksheet function
  88. Median Array
  89. Pulling a # from a sheet bound text string
  90. Linest
  91. How the heck?
  92. Vlookup
  93. Resolve Circular Ref Issue
  94. Count of times a number is repeated by date?
  95. isblank
  96. Len
  97. Linking Spreadsheets
  98. lookup between two worksheets not working well
  99. Seperate Text and numbers in Post code
  100. Mergeing Cells
  101. Config Now() troubles
  102. How can I make a running total change in a new cell
  103. Summing numbers dropping lowest and highest
  104. Need Help for win, loss, tie score sheet
  105. IF formulas
  106. "Worksheet" "Change" using VB
  107. Not Sure on Function
  108. compare columns
  109. Create a drop down box in a column with specific entries ?
  110. updating query in excel
  111. Linking using Macors
  112. Help formula that returns a text string from another sheet
  113. Help Please.....numbers reaching limits and cells changing colour
  114. Compare Sheets values in two colums
  115. Vlookup
  116. where i can find tools menue
  117. Pick up values by parameter
  118. CSV loading incorrect
  119. Loan Payment Schedules
  120. convert 8 hours and 45 min in to 8.75 hours.
  121. Dynamic Range
  122. Find the next occurance
  123. Hyperlink that copies Data
  124. Macro Help
  125. Problems when sorting data containing array formulas
  126. Need Help Resolving Circular Ref
  127. What formula can I use to sum largest 2 numbers out of data set?
  128. Lookup value then return result from other column, varying row num
  129. Excel Question
  130. Booking forms
  131. File Search command 2008
  132. is it posible to have a formula for factorial via vba code?
  133. Format Arabic Numbers
  134. Vlookup
  135. Modify a vLookup?
  136. Proč se mi v aplikaci Excel zobrazuje soubor PERSONAL?
  137. Need a Static Timestamp Formula
  138. Flagging cell entries in a column to add to a subtotal.
  139. a1 = sum(a1;a2)
  140. average of different rows
  141. highlight selected cells in excel and blackout others for sharing
  142. Autoincrementing dates
  143. Excel 2007- color on current workshet only shows in pre print prev
  144. date format
  145. Return horizontal and vertical values
  146. Checking Lotto numbers
  147. External Links in Excel 2007 with variable source file
  148. Find first occurence of a number in an array 7 cols wide
  149. Pivot Table - How to Set and Preserve my Formating for all futurepivots
  150. Text Colour
  151. Added Table
  152. how can I make a cell content equal the tab name 'sheet1' ?
  153. Re: Return MAX value Offset 1 Row from Criterion and count occurrence
  154. How can i Show ....
  155. how do I invert all of my cell entries ?
  156. print borders on spreed sheet
  157. Excel 2003
  158. worksheet cell display
  159. LookUp to Display Last Value Populated a in Range
  160. Extracting numbers from alphanumeric strings
  161. Hidden Worksheet
  162. How do I compute annual rate of return in Excel?
  163. How can I exact no. from text string? E.g ACBE123445te
  164. Match similar phrases from 2 worksheets
  165. pasting same data over many cells containing a formula
  166. Need help with range value calculation
  167. Need a Lookup/Sumif Combo Formula
  168. Functions for "current" & "previous" month to calculate data
  169. Conditional Formating - How to emphsize the current Month
  170. Linking to another file using file reference typed cell
  171. Filter for value 1 in two columns
  172. Average days between multiple dates
  173. Copying text to new cell
  174. Repeating numbers in same cell
  175. Formula help
  176. Copy rows but need to refer to same cell in original formula
  177. Sumif a set of corresponding values
  178. Countif a corresponding value is not equal to zero or blank
  179. Compare worksheets with multiple data
  180. Highlighting Data IF...
  181. Is there a way to enter a comment on a locked cell in Excel?
  182. Sumproduct Fucntion - the use of dash ( -- )
  183. Pivot Table - how to add column on the same row
  184. How to: If D4 = Yes then Calculate C4/11, if D4 = no leave blank
  185. VLOOKUP returns #N/A
  186. lookup single value in one sheet, return multiple results from theother sheet
  187. Macro help needed :(
  188. linking cells to mutliple worksheets.
  189. need formula to pick a value every certain set of minutes from large database
  190. Duplicate all of the rows in a worksheet
  191. Vlookup again!
  192. VLookup Help
  193. Sum column with errors, Macro
  194. Rounding (decimal) elapsed time
  195. If functions
  196. vlookup then average 3 above and below
  197. vlookup returns formula instead of value
  198. I need to expand my code for mandatory cell entry - Need help!!
  199. after inserting a "drop down box" I want the drop arrow to show
  200. Rang reference incrementing by more than one on formula drag
  201. How do i convert from HEX to BIN
  202. Add to this formula to make it work
  203. More date calculations
  204. & in formula changing date format to text ?
  205. Round up based on pre-defined integers
  206. How do I delete pages in a worksheet?
  207. Rounding a date up to the 1st of the next month
  208. Misbehaving Tab
  209. print front and back
  210. Case Sensitive LookUps
  211. How can I skip first the first occurence in an index search?
  212. Nesting
  213. Printing a worksheet with a Drop Down List
  214. How do I make a cell stay blank if "0" result?
  215. % of difference between two numbers
  216. Dependent DropLists - Using Validation
  217. Custom formatting
  218. VLOOKUP difficulty sorting data?
  219. Excel
  220. coounting references between sheets
  221. Macro for removing specific rows and columns, freezing panes..?
  222. checking for a particular string in a cell
  223. Pivot Tables.
  224. workbook referencing problem
  225. PMT function?
  226. Concantenation Problem
  227. Formula Help
  228. New to VLOOKUP function
  229. Calculation on Pivot table running totals
  230. Wobbled countif and conditional format Results
  231. Ranking
  232. Conditional Formating copying (Max Min)
  233. Negative numbers in resulting formula
  234. Finding percents of a total
  235. Modify A Macro To Recognize Case Sensitive
  236. 30 levels of nesting excel
  237. Limited amount of cells in a formula
  238. How do I get more colour choices to fill a cell?
  239. Excel Macro Help
  240. Combining data from two columns into one - appending new values tothe end of one column
  241. Cannot unhide rows
  242. Can Excel list all of a workbook's worksheets on a worksheet?
  243. Shared Worksheet Mixed versions 2003/2007
  244. The VLookup function displays the formula in the cell, not data.
  245. Copy Linked Cells
  246. Excel - Sorting groups in groups due to subtotaling
  247. RE: VLOOKUP again
  248. Formula to lookup worksheet label
  249. If - Then formula
  250. Expand a Spreadsheet
  251. Totalling coded values
  252. Help to build a Look Up Function or What Ever Function Excel 2002
  253. lookup for worksheet
  254. Excel 2003 - Split Content of Cell w/Text Separator (Return)
  255. Formulas in a cell
  256. Extracting characters from a cell
  257. Count the number of Commas found in cell A2
  258. Missing Data Label on XY Values
  259. need VB Code
  260. Stop named ranges from copying into other workbooks
  261. Nested If
  262. Dates
  263. Archiving an Excel Sheet
  264. RE: Having problems to add additional info to this string....
  265. Problem with Pasting into Filtered Fields
  266. Sorting data by columns
  267. Filtering and Hilighting Data
  268. interest calculations
  269. Conditional Formatting to match cell values
  270. IF a cell = YES
  271. Help with formula
  272. Calculating time & subtracting lunchbreaks
  273. Format pivot table / column width
  274. sumproduct problem
  275. Copy a hidden Cell
  276. Match Corresponding Rows and Add Fields Together
  277. Count Common Denominator, but excluding "#value!"
  278. Help using formulas and trickery PLEASE
  279. Indirect Function() - summing across sheets
  280. the formula sees the cell with a value
  281. xlDynamic.com
  282. Sum if Date is?
  283. Print with cell value
  284. Apply Data Validation List only IF . . .
  285. Grouping
  286. week ending
  287. Can I create a header in table forms?
  288. trying to write a formula for payroll
  289. How Can I remove certain DATA
  290. AutoFilter Made Easy
  291. why cant i subtract one cell from another?
  292. Data
  293. Another Timesheet Question
  294. Timesheets
  295. Date question? update year.
  296. Conditional Formating to Show Numbers NOT Divisible by another
  297. How do you link one sheet to another
  298. Conditional Formatting
  299. Leave Cell Blank Continuously
  300. how do I reflect a (-) outcome as 0
  301. conditional formatting
  302. How to insert a row without losing data in INDEX formulas
  303. vlookup function
  304. Multiple cell conditional formatting using the IF
  305. Cross referencing columns
  306. Using the sort function for a date column where year was not enter
  307. Comparing changing Data
  308. VLOOKUP and AutoFill
  309. Automate Column Amts
  310. What function should I use to pull those records that match
  311. Re: SUMPRODUCT Adaptation
  312. Re: SUMPRODUCT Adaptation
  313. How do I use specific characters to hold value
  314. Help with saving a Macro
  315. using handle with formula
  316. Convert an Excel list to a Range
  317. Can I get Excel to populate a cell with the soonest date in a rang
  318. Indirect sheet reference in a cell
  319. Getting Data from Closed Workbooks
  320. Need a function for my teaching plans
  321. Sum columns up to vlookup value
  322. Protect Drop-down list from range of cells
  323. Pivot Table - Grouping
  324. Conditional Formatting Based on Date
  325. Duplicate Macro for Closed Workbooks
  326. 0 As Default Value
  327. #VAlUE
  328. RE: Subtract
  329. Problem with chart
  330. Formula not updating to new content.
  331. Sorting of data
  332. Not sure if count is the correct formula... Excel 2002
  333. Finding subsequent matches
  334. RE: String vs. Table Look Up
  335. How do I calculate text data in 2 different columns?
  336. Re: Adding additional string vs. look up table
  337. again display "missing" when blank
  338. display "Missing" when blank
  339. Matching Records
  340. Not finding matching value in vlookup
  341. Table with formula
  342. RE: Having problems to add additional info to this string....
  343. How do I hide subcategories in Excel?
  344. Sheets comparing
  345. HELP IN A FORMULA
  346. Finding date of the month
  347. Need help with Date/ and find most common denominator.
  348. Symmetric Difference or Derivative
  349. Determining length of trend before significant retrace
  350. Looking up the value corresponding to the last repetition in a ran
  351. 1 column alpha list in excel to print to 2 columns
  352. simple question on formulas and autofil
  353. Re: VLOOKUP should be and easy one
  354. RE: Without using a macro?
  355. RE: Date - I would like to skip weekends in a date range
  356. if greater than?
  357. If then formula
  358. Percents
  359. RE: Help with function please
  360. Re: If then formula
  361. Re: Color Alternate Rows
  362. Calculate Count of Days & Average WHERE Amount <>0
  363. Re: Target.Value
  364. Help with formula
  365. different SUMIF
  366. TimeSheet Using 100 Minutes & Rounding to .25
  367. Re: Count x2 Appearance of Numeric Value in any Row
  368. Internet - Take Advantage of Multiple Windows When Surfing
  369. Conditional Formatting
  370. Summarizing Data
  371. Extract "Does not equal" data
  372. SumIf help
  373. average filtered values
  374. Mutiple COUNTIF or equivalent.
  375. Cell to match footer
  376. Time format
  377. CONDITIONAL STATEMENT
  378. Adding up values from separate tabs
  379. Data validation - custom (must have "/")
  380. Finding 3rd (or 2nd) Sunday in a given year/month
  381. Increase Your Business By Data Conversion, Data Format and Data EntryServices in India
  382. Conditional Formatting Problem
  383. save excel 2007 spreadsheet as a .wk1 file?
  384. removing sending mail warning
  385. Rank based on criteria
  386. HOW CAN THIS BE DONE?
  387. Keeping lead zeros in excel text format when saving as CSV file
  388. Pivot Table Data
  389. Re: Or, index, match statements
  390. Lookup
  391. Adding from several columns if ...
  392. RE: Or, index, match statements
  393. Re: Or, index, match statements
  394. excel programer needed
  395. Make CommandButtons Not Visable With A Macro
  396. VLookup Enhancement
  397. How do I change the name on comments inserted in Excel
  398. Divide 2 pivot table numbers
  399. Formula required for a gas logbook
  400. make a positive number to negative
  401. Concatenate many rows quickly
  402. calculating by month
  403. sumup question
  404. How do I vlookup multiple rows with same reference?
  405. Annual return formula
  406. Sunday
  407. Text to Numbers
  408. IF function - If false argument query
  409. Returning matches from mutiple rows
  410. help with code in a mack
  411. VLOOKUP
  412. date and time [skipping weekends]
  413. Conditional formatting II
  414. separating linked wrkbooks
  415. Zero Values
  416. PageSetup Macro
  417. Excel User Tracking
  418. Conditional formatting
  419. Manipulating data in Multible worksheets
  420. Extending Look-up to multiple cell ranges
  421. Search and replace function
  422. Pasting Borders
  423. pulling data from 2 columns
  424. Macro to summarize data
  425. Need Formula to Find a Match and Then Insert Some Characters
  426. Conditional Calculations with Calculated Results
  427. shortcut key for selecting the inactive cells surrounding a range
  428. Hidding tabs under a specific summary tab
  429. trying to consolidate info into one sheet
  430. Import data from Word
  431. Drop Down Menu autofilling
  432. Count Days more than 180 days prior to today
  433. Cumulative days roll-over
  434. Table feature in Data Menu
  435. Linking values within an Excel workbook
  436. Making list of unique items from two different columns
  437. Generating a new list based on cell criteria
  438. Copying formulas
  439. Sumproduct Offset with an If
  440. Conditional Format Based on Age, but not if blank.
  441. Change a 1,2,3 or 4 digit number to a 6 character text string
  442. Is there a function that will email a spreadsheet if changed?
  443. in excel how to pull only used information to another sheet
  444. adding time
  445. Is there a way to make a ratio alterable?
  446. Count if cetain text is in another column, same row.
  447. VLOOKUP DATA
  448. Horizontal merging of cells
  449. Variable reference in countif
  450. Using Solver
  451. Shading rows
  452. subtract a positive from a negative
  453. converting files to excel
  454. lookup needed for names in varying order
  455. Countif with date range criteria
  456. How to concatenate cell & text in a text box?
  457. #n/a result for vlookup
  458. Duplicate rows into new rows based on row value
  459. Alternative to IF
  460. How to force data entry with error messages
  461. VLookup in Excel 2003
  462. sumproduct - strange
  463. IF and Vlookup
  464. Formula to Populate Cells
  465. Kendall's tau
  466. Is there a limit to the number of formulas in an Excel worksheet?
  467. Excel Formula to concatenate record from 2 tables
  468. How do I test a specific color in 2003?
  469. HOW DO I INSERT A MULTICHOICE SELECTOR IN EXCEL?
  470. Error in if condition
  471. Sum the values of cells based on fontcolor
  472. help on sumproduct() - sum by searching for a common sub string in
  473. How to know a cell contain the formula
  474. Delete options for AutoFilter?
  475. Need formula in excel for filtering large database
  476. Daily data to weekly data conversion in Excel?
  477. Calculating percentage of Shaded Cells in a row
  478. Need more than 7 formulas in one cell
  479. Update link without openning the source/destination files
  480. Moving within the worksheet
  481. Excel Guru Needed For Formula
  482. VLOOKUP PULLING WRONG DATA
  483. Excel user defined functioned
  484. Excel - How do I get Excel to spell out a current amount?
  485. Advanced text function (combining text)
  486. Question with a formula
  487. Lookup to Show Empty Cell
  488. VLookup and cell shading
  489. Averaging set of data based on the time
  490. Excel 2002...
  491. Sumifs - greater than criteria with a Cell Reference
  492. NUMBERS SHOWING DIFFERENT AFTER TYPE
  493. Inserting comments
  494. Sum per row and Average per column from a second sheet.
  495. How do I write thia function?
  496. Transforming table's content/display
  497. Simple Indirect Function?
  498. better way to write a count if statement?
  499. re-organize data in fixed blocks
  500. formula to count occurrences
  501. Best way to subtotal this data?
  502. I forgot my password
  503. track changes
  504. Fill color wont' stay
  505. Remove useless information
  506. Annual leave monthly calculation
  507. Locking/Unlocking based on another cell value
  508. To VLOOKUP or not to VLOOKUP......
  509. CommandButton self reference
  510. Count all rows in column with data, Except rows 1-5
  511. V Lookup and Paste Special
  512. Concatenate question
  513. Sick Time Reports
  514. A question of two inputs
  515. MAX Value
  516. Average Grade
  517. Cell selection highlight colour
  518. COUNTIF q re dates and blank cells
  519. Re: Sort
  520. stock inventory
  521. Calculate days in each month
  522. blank cell verses using zero
  523. 93245 - descr-ip24tion: Q-how do i only extract 93245?
  524. Arguments Count Function problem
  525. Converting PDF Files to Excel
  526. sumif function in excel for multiple conditions instead of one
  527. How do I delete a page in excel
  528. Blank Date
  529. Reverse Index and Match Functions
  530. Run a macro after clicking into cell
  531. Get error message about copying cells with more than 255 characte.
  532. Drop down options
  533. Double Vertical Index & Match
  534. rotate columns
  535. Second Saturday Of The Month
  536. Help - Just started using Excel 2007 and need help finding an Add-
  537. I need to make a sum function always equal the corresponding cell
  538. How do I require data entry in a cell before moving to the next ce
  539. Help! -How to compare two worksheets; multiple rows of data=result
  540. .csv
  541. Adding new rows in between rows...
  542. Sum with multiple criteria using SUMPRODUCT
  543. I need to make cell a1 on sheet 2 ALWAYS = a1 on sheet 1
  544. How do I add many rows in between existing rows in spreadsheet?
  545. Cross Referencing two data worksheets and desciphering differences
  546. Sum data if 3 criteria are met
  547. Nested IF: Using CPEARSON Approach
  548. How do I make a cell blank if Error OR 0 Result
  549. Offset Function
  550. FIND SPECIFIC TEXT AND REPLACE IT
  551. F4 Function Key stopped working
  552. Reporting on multi worksheet spreadsheet
  553. Universal formula to all cells
  554. Sub-total outlines
  555. Copy And Paste Macro Syntax Problem
  556. switching between formula display and value
  557. Viewing Protected Cells en mass
  558. RANGE EXCEL copy cell that meets criteria in a range
  559. Hard to do? randomly
  560. Hide blank data
  561. convert date
  562. Excel POPUP
  563. Using Degrees in trigonometric functions
  564. Ensure that all numbers are 8 digits long
  565. Can I recognize the specific letters in a cell using formulas?
  566. Error in vlookup result
  567. Can you help me ?
  568. sort in EXCEL
  569. Excel formula for adding up sub-totals in time format
  570. Highest 3 in 10 Consecutive Numbers
  571. summary Sheet
  572. How we can hide the rows no. 1,2,3,4,.. &Column no. A,B,C,D...AA
  573. Paste A Cell Formula Into A Cell With A Macro.
  574. Excel alert/Notification
  575. DATEVALUE, etc. and Australian date format
  576. Dates
  577. counting names
  578. Formula for degree days
  579. Conditional formatting to highlight the lowest valid value
  580. In Excell, how do I change the date from 39443 to 12/27/08?
  581. Copy, next blank row?
  582. Date Range Conditional Formatting
  583. Adding fileds in a list based on a lookup
  584. Printing subtotals on each page
  585. Lookup?
  586. Conditional Format
  587. Count/if/and function?
  588. Date formual issue
  589. Sorting information within a cell.
  590. Can i create an IF statement that looks for just numeric values?
  591. find a cell in a range and copy another cell
  592. how to set number format for the entire excel sheet
  593. Calculated Fields in Pivot tables - Help
  594. Copying the active worksheet to another worksheet in the same work
  595. worksheet has numbers where the letters are on top of the columns
  596. Formula works on all but one worksheet
  597. Count If combined functions
  598. How was user able to (accidentally) change an unlocked cell to loc
  599. Will FLOOR & CEILING work with variable stratifications?
  600. Long formulas for totals
  601. Floating comments in Excel
  602. Sumproduct issues.
  603. How do i enter the date in column instead of # sign?
  604. look up formula?
  605. return sporadic numbers in a cell-area from a spesific number
  606. Help with Search Formula
  607. Sorting
  608. Sum Multiple Matches
  609. Missing values when using TREND
  610. Need help with IF command
  611. how to calculate average loan period of a 5 year loan
  612. COUNT based on 2 criteria
  613. How To Reference What Is In A ComboBox In A Cell Formulas???
  614. Compare two files and find records without matches
  615. expert help needed for better alternative to slow workbook
  616. How do I reference a value to consecutive merged cells
  617. how can I calculate cells containing words yes or no
  618. How to auto tab
  619. Very difficult, please help with copy
  620. =SUM(I47:I115) What does the "I" mean and how is it used?
  621. Import & Refresh- Changing Formulas
  622. How to SUM in a protected spreadsheet
  623. Excel
  624. IF-Then formula problem
  625. RE: Urgent Help
  626. NOW() function help...
  627. RowSource for Sheet ComboBox
  628. VLookup: Get a value from a different spreadsheet
  629. cumulative return
  630. how do you force a new line in a formula in Excel?
  631. Formula to send answer from 2 sources to one column
  632. Re: One Workbook for Each Worksheet
  633. deleting a cell from series , why the series gets disturbed?
  634. permenent appearance of the drop down arrow when adding validation toa cell
  635. I think i need an if and maybe something else
  636. if not function
  637. getting comment pop-up
  638. Help with formula
  639. How to connect the Excel 2007 in SQL Server 2005?
  640. Lookup and offset at the same time?
  641. if v lookup formula
  642. "SUMPRODUCTIF"
  643. Save as CSV file
  644. can excel calculate payroll taxes?
  645. Comparing a cell value to a range
  646. IF Statement
  647. #N/A is showing up throughout worksheet
  648. Copy formulas
  649. Copy contents to another page
  650. Modify A Formula
  651. If then with wrong return value
  652. Add alternate cells in column and sum
  653. offset reference
  654. Re: lookup help
  655. Array in formula Vlookup changes when data list is added to
  656. sort and sum data range with some blank cells
  657. Formula to sum blank cells
  658. When word says Install I want it count the days for 3 days w.o wee
  659. Hyperlink display problem
  660. HOW DO I CONVERT A NUMBER'S MOST SIGNIFICANT DIGIT TO A SINGLE DI.
  661. Referring to a variable cell on another sheet
  662. Time or row cell updated
  663. One-click hide or unhide rows & columns
  664. Summing based on various critiera
  665. I need to alert users with errors and warnings on a excel 2003 tem
  666. HOW TO ROUND UP INTEGER VALUES TO NEAREST TENS EXAMPLE 376 TO 380
  667. 3D summing a named range.
  668. add cells on multiple worksheets using specific criteria
  669. Validation List with Value to pop up automatically
  670. Counting values in every other column
  671. #N/A Error with VLOOKUP
  672. Have 2 worksheets work together
  673. Graph attached into cell
  674. how can I pick up a nearest value to zero
  675. Automatic Negative Column
  676. multiple If's based on today's date
  677. conditionally highlight unprotected cells
  678. Return 1st, 2nd, 3rd largest test values
  679. Hyperlink Question -- Change in Worksheet Name?
  680. Sort column B but keep value in column A with value column B
  681. Conflicting results in formulas?
  682. How do you have the cells highlight changes? (no track changes)
  683. Consolidation Referemnce is not valid
  684. how do I set tabs in Microsoft Office Excel 2007?
  685. Sum serie with condition
  686. How to combine SUMPRODUCT with COUNTIF?
  687. compressing long columns into subset averages
  688. Compare Col A and Col M, if Match, Copy Col N to Col E
  689. return maximum text "value"
  690. macro for inventory/shipping labels
  691. How do I pull certain data out of spreadsheet and import into another?
  692. SUMIF PROBLEM
  693. Standard Error Question
  694. Does anyone know if excel has a function to calculate standard er.
  695. macros with functions
  696. Julian date - find next highest date/number
  697. Conditional formatting: changing number format
  698. Summing Unique Entries
  699. How do I sort the whole row at once in Excel?
  700. TIME SHEET
  701. Querying Worksheets
  702. How do I enclose all data values in a column in double quotes?
  703. unable to protect cells in macro sheet b/c runtime error 1004
  704. formula copies value from original cell only
  705. Random Selection
  706. Font Size in Drop Down Menu
  707. Countif problem
  708. make excel automatically add a decimal
  709. index, match, offset worksheet function
  710. Max and Min
  711. sequential numbering when printing
  712. Complicated lookup/match formula help needed!
  713. Column Heading with black up_down arrows
  714. An IF question plus Printing Macro
  715. Temp Stop and Start Recording Macros.
  716. exit cell automatically after entering data
  717. Different colum widths for same colum in different areas of worksh
  718. Converting time from text to numeric
  719. excel????
  720. TABS in Excel 2003
  721. Repeat rows on top - in worksheet - not printing!
  722. Convert time unit
  723. Autofilter in Excel
  724. what is a group excel file and how do i disable so i can sort it?
  725. VLookup takes too long
  726. Lookup and Change Values
  727. MS Excel 2003 Certification (Help)
  728. Remove number from text string
  729. RE: Remove number from text string
  730. CELL REFERENCE
  731. HOW TO USE LOOKUP
  732. value_if_false returns formula
  733. display time in 12 hour format
  734. MS Excel Data Validation, Ignore Blanks in List
  735. Can I open Excel 2000 spreadsheets in Excel 2003?
  736. Count by 10
  737. Show formulas result + text directly
  738. Using 2 cells in a table to retrieve data from another table
  739. How do I underline just 1 word in an Excel cell that is a formula?
  740. Delete duplicate entries from Excel 2003
  741. Converting Excel 2003 WS to Exccel 2.1 WS
  742. Text Formula
  743. I need a formula
  744. Scroll lock is stuck and won't turn off
  745. Using variable cell references in Excel? eg A[B42] instead of A7
  746. MULTIPLE NESTING WITHIN EXCEL
  747. Help for marco to autofill in down the row
  748. list from empty data cell source
  749. How does one get excel sum of a column based on given dates range
  750. How to delete blank rows at one time in a long excel spreadsheet?