Functions

Calculation of weighed average
I have a number of cells in a row, D3:K3 (actually the row will contain columns up to FZ). These cells can either contain a number o4r be empty. An example could be D E F G H I J K 2 4 7 2 - 2 - 7 The "-" indicates an empty cell. Now what I need is a formula, that takes the sum of all the c... 9 Apr 2010 04:33

How do I filter cells based on character case in Excel
Hello, I have a column of user passwords, some in all Uppercases, some in all smallcases while others in mixed cases; Please how do i filter based on cases? ... 9 Apr 2010 05:38

sumif..
my condition is : A B C 1 Date Name $ 2 15/2/10 John 15 3 16/2/10 Mike 8 4 28/2/10 John 21 5 01/3/10 John 10 6 05/3/10 Mike 15 ... 12 Apr 2010 20:23

hyperlink help
I have this \\Pwreports\PWREPORTS\2010\197\2010000005_NIBRS Incident Report.pdf I can make the hyper link work once, ( flashes real fast and disappears) I need change two things the 197 and 2001000005 The 197 is the ofc badge and is located in cell bh6 and the 2010000005 is the case number and is loca... 8 Apr 2010 21:57

Alphabetizing
I cannot figure out how to alphabetize my entries in Excel 2007. In 2003 I just clicked a button. How do I do that in 2007? thanks ... 8 Apr 2010 20:51

How to count merged cells
Can someone help me in developing a formula that will: 1. Count how many merged cells in a column that are created from 2 cells AND contain both text and numbers? 2. Count how many merged cells in a column that are created from 3 cells AND contain both text and numbers? 3. Council how may merged cells in a co... 9 Apr 2010 17:53

SUMIF Function
I would like to use a SUMIF formula to add multiple columns. For instance, I have a list of materials in a range from A6:A2403 and sales dollars for each material, by month, in columns H thru S. I want to be able to perform a SUMIF function to add Jan, Feb, and Mar sales dollars for any given material. Can a... 13 Apr 2010 20:43

how to count#cells w/= value in other column and not count bla
Thanks, all three suggestions work! "Stefi" wrote: =SUMPRODUCT(--(A1:A9=B1:B9);--(NOT(ISBLANK(A1:A9)))) -- Regards! Stefi „aganoe” ezt írta: In column A, I have values equal to either YES, NO or NA. In column B, I have values equal to either YES, NO or NA. I wan... 9 Apr 2010 06:43

Excel 2003 formula
I'm trying to make a formula for a list to check and strike out another on 3 sheets. Only 2 are using the info, sheet 3 has various colums to check. Sheet 2 A B dog yes cat (blank) Sheet 3 A C E etc... Dog(striked) Blank Dog(striked) ... 10 Apr 2010 15:43

How enter time DURATIONS mm:ss (not clock times), then sum?
I want to enter a column of data as time DURATION (not clock time) in mm:ss format and then sum the total. What cell format should I select for the duration entries (mm:ss does not work) and what calculation steps do I need to use to sum those durations? ... 8 Apr 2010 19:43