Functions

Drag Mouse and Add-up
Hi there, I used to be able to drag the mouse over several cells and pick other cells as needed with [Ctrl] & Click. The sum of all these cells would have shown on the status bar. Somehow, I lost that capability and I do not know how to get it back. Appreciate your help, ... 25 Mar 2010 23:12

COUNTIF for 2 columns
I'm trying to set a parameter of the following in a formula in column J: =COUNTIF($C:$C,$B300) That also only counts the number of times in column J where a cells (J1:J299) value is greater than "0". ----this is where I can't figure out the how to?? In other words, I need to set-up a formula in column J row ... 29 Mar 2010 14:45

data not carrying over from access to excel
When I am running a query in MSAccess 2007 I get 1315 records, when I run the query via Excel 2007 connecting to the DB it stops at 691 records. I'm a little rusty, this is my only query where in the criteria I have an "or". I was thinking if this had anything to do with a second pass or am I just not calling i... 25 Mar 2010 17:28

Filling formulas with specific cell references remaining the s
Thanks. I tried all sorts of symbols, like single quotes, double quotes, and paentheses, but I never thought to try the dollar sign. "David Biddulph" wrote: A suitable topic to type into Excel help is "relative & absolute addressing" The dollar sign in a reference makes the row, or column, absolute. -- ... 25 Mar 2010 15:02

sorting data
I have a column of data that repeats every 10 rows. that is, the data type is repeated every ten rows. I want to reorganize the data in that column into 10 columns (one column for each row). How can i accomplish this? example: I want to distribute column A: column A date1 name1 age1 date2 name2 age2 et... 25 Mar 2010 22:03

Jpeg links opening in Explorer instead of Picture Manager
I've set up a spreadsheet in Excel 2003 that has links to jpegs. I've gone back in to add more photos but am having problems with the links. I added 6 photos all from the same folder and all about the same file size. However, 4 of them are giving me the "red x" box. I don't understand why 2 are opening whil... 25 Mar 2010 15:02

convert vertical to horizontal
I see lots of post but not one I can use. I am looking for a "function" that will take vertical data to horizontal. I don't want the copy,paste, transpose please. Example : 1 2 3 Results 1 2 3 thanks! ... 25 Mar 2010 22:03

Trying to match 1 value to multiple columns
I have a spreadsheet with several different worksheets. On Worksheet 1, I have the following: (Col A) Structure Number, (Col B) Opening Height 1, (Col C) Opening Direction 1 (N, S, E, W), (Col D) Opening Height 2, (Col E) Opening Direction 2 (N, S, E, W), (Col F) Opening Height 3, (Col G) Opening Direction 2 (N... 26 Mar 2010 12:01

Repost - Functions on filtered data
Afternoon, Sorry i forgot to put in the formulas concerned. Second time lucky! I have an excel sheet of 10 cols and 200 rows on sheet 1. Sheet 2 has a table which searches through the list of data in sheet 1 to 1 - produce a list of unique items using the formula - =IF(IF(ISNA(MATCH(0;COUNTIF($B$3:B3... 25 Mar 2010 12:40

First Day of the month
Does anyone know how to have excel look at a cell that has a date that is formatted as xx/xx/xxxx (E.g. Cell A2 = 01/16/2007) and show the date as 01/01/2007 in B2, another words view as date as first day of the month. ... 25 Mar 2010 22:03