I was wondering if it was possible to use 2 criteria for a count if formula. I want to count the number of numbers in a range that are above 0. I would write...

I have a question about how to write a formula to include specific info in a range of cells. I have a range of cells I want to include in a formula but I want...

In a worksheet of mine I have a bunch of dates in column A in the format dd/mm/yyyy. I also have data in between the dates in that column and I was wondering...

Hi, I am trying to replace dashes (i.e.: 0123-456-7890 to 01234567890) with blanks, but seem to be losing leading and trailing zeros. What is the...

I am trying to create an easy way to keep track of player rotation for batting and field positions for eight games.

Ok I'm in a bind , I would like to be abel to keep track of my girls softball team rotation. I would like to keep track of batting order and player positions...

I am trying to set up something to help me keep track of player rotation for my t-ball softball team. I have 12 girls we play 8 games and all girls play...

I'm unable to understand what use a "+" sign has if it is put before a formula. For ex: +(C13*(1+$M$10)+J13)/(1-$M$12) gives the same result as...

How do I get rid of Icons? I have two I would like to get rid of as they are merely a nuisance for me. Euro Conversion and Euro currency sign. I do not think I...

Does any one know where I can get/download a step by step (beginner) on the following - Pivot table, SUMPRODUCT, VLOOKUP, MATCH ? These are just for now. If...

I am trying to convert Dollar amounts into written text in an excel spreadsheet. How do I create a formula that will convert my Numbers to word text. i.e....

Is there anyway to convert a file with columns back to comma delimited? --- Message posted from http://www.ExcelForum.com/

I can't figure out how to remove a specific thing from my column.. I have mailing addresses with number and street name in column a, city and state in cloumn...

ok, so i need to save this file to a comma delimited file. But I had to create columns to change some info.. How do I get it back to comma delimited? I...

Hello .. I am trying to set up a form for data entry which will use Column labels as field names for data entry on a form. I used the "Label" option on the...

I have merged two cells (vertically) and would like to change the "line spacing" for text entry .. I would like the text lines in the merged cell to be closer...

I finally got it to work from the code below: Sub Uhrs() ' ' Uhrs Macro ' Macro recorded 7/3/05 by Abay ' Keyboard Shortcut:...

I realize that I also need to be able to refer in relative terms to the workbook next to the current workbook.. So what I need to is to cut and paste the...

I am pretty much a newbie at Excel and would like to create a Macro for the following: (know how to create and edit macros etc.) Take the value from a cell in...

sum command do not display the result eg:=sum(c5:c8)-total not display the result in the cell even when sigma is clicked the same