Functions

SUMPRODUCT or COUNTIF FOR TEXT VERIFIED LIST
I need to count a total for a series of text vales and multiply that by a number that appears in a a corresponding cell in an array of text. The multiplying number is always relative to the text. Also not sure if it affect things but the Text is derived from data verified drop down list. eg: COL 1 COL2 COL3... 13 Jan 2010 04:22

how do I dropdown list
I need a drop down that will show a code and a description of that code, but after I select it I only want the code visible. ... 12 Jan 2010 20:48

If sign of sum is negative change to positive
I am using a formula that may produce positive or negative results. Once it has produced the sum the sign is immaterial. I need the result to add as a positive. I need something that says if the sum is less than 0 change the result to positive. How do I do that? ... 12 Jan 2010 15:13

Comments
Can you tell me how to add comments to an individual cell when the worksheet is protected? The option does not appear on the toolbar nor when right clicking. ... 12 Jan 2010 19:42

Mapped vs Network drives
hi, is there a way to show a network drive via formula when a drive is being mapped? Different users mapping of the same drive to a various letters is causing issues. I thought of writing an UDF combining a string with a network drive name with a combination of cell("filename") & hyperlink function, but ... 12 Jan 2010 15:13

Insert a new Worksheet AFTER the existing (Active) sheet
I want to insert (or add) a new Worksheet to my existing Workbook, but I want it to appear AFTER my existing (Active) Worksheet. The default places it BEFORE my current sheet. This places Sheet2 before Sheet 1. I'd like the new sheet (Sheet2) to be added AFTER Sheet1. Is this possible? ... 12 Jan 2010 17:28

How do I get my data back in excel after hiting F11 by mistake?
I was working on a spread sheet in excell and hit F11 key by mistake. Now I can't get bat to the data I had and was working on. What do I do? ... 12 Jan 2010 11:50

Caps Lock vs Lower Case
Hi, I need to convert cells that was typed in caps lock only, to lower case. How do I do this without having to retype the whole cell?? ... 12 Jan 2010 11:50

Counting consecutive numbers in a list
I'm looking to take a list of twenty numbers and count the number of times in that list two or three consecutive numbers appear in it. Any ideas? ... 11 Jan 2010 17:39

Formula displaying don't know why
I put a formula in a worksheet and instead of making the calculation the formula is showing. I checked Tools/Options/View but Formulas is not checked off. Also Tools / Options / Calculation is set to automatic. Do you know why this is happening ... 11 Jan 2010 17:39