Functions

Summing Data based upon a condition
Hi, Trying to "Sum" data in one column (A) based upon a condition in another column (B)....... Any help? -- Chris ... 8 Apr 2010 14:03

How to copy & paste a worksheet but change 1 bit of the formula?
I want to copy a worksheet names WK 15 that has several formulas in linking to WK 15 of other sheets, then paste it to create another workbook but changing all the formulas to WK16 and not WK15 but keeping all of the other data within the pasted formula the same. EG: SUM('Y:\AREA\PARADE\[WK 16.xls]Sheet1'!D$6)... 8 Apr 2010 15:12

Sorting
When trying to do a sort the data tab & several other tabs are unavailable or shaded in my Microsoft Office Home & Student Excel 2007. Is there something that needs to be turned on or off that I'm not aware of? What am I missing? ... 9 Apr 2010 10:02

complicated drop down menu question
Hi there, Perhaps someone can help me with this issue, it's a bit long so bear with me. I have 2 spreadsheets, the first one is called data, the second one is called summary On the data sheet, I have it lay out as a sample like below, in different columns, all in text format week 1 Jan 1 Jan 2 Jan 3 ... 8 Apr 2010 14:03

change multiple links at once
Hello, I have a master spreadsheet that has multiple links in it from 150 other spreadsheets. Needless to say it was very time consuming to link certain rows from each spreadsheet. If there is a way to automate this for the future, I would very much appreciate the info. I have no exp in VB by the way. :) ... 8 Apr 2010 12:37

.csv to .txt
Very simple question here. I'm implementing a process whereby I need to ask an operator to change both the name and format of a file. The format must change from .csv to .txt If i ask them to simply change the file extension while changing the name rather than opening the file > save as > etc. is there any po... 8 Apr 2010 14:03

Hiding rows and printing
I have the print area set to A1..H340 with 4 manual page breaks inserted. I have hidden rows 200 thru 340 and when I print, I still get 5 pages - two pages from the active rows and three more that are blank. I have been doing this "hiding rows and printing only what I need thing" for over a year now and it ha... 8 Apr 2010 11:05

Date chart formula question?!?1
Hi all, In a very old spread sheet i was using this formula =IF(OR(AND($D7<G$6,$E7>F$6),AND(F$6>=$D7,F$6<=$E7)),".","") and it worked for dates pre 2009. However, i now wish to use it for dates between 2010 - 2011. Each column represent a week and the rows will indicate and project or task. can anyone hel... 8 Apr 2010 18:35

how to convert amount into text automaticaly in excel
... 8 Apr 2010 14:03

How do i compare and remove common names from 2 excel work sheets
Task is to compare 2 excel worksheets containing humngus list of companies names' (approx word match only in each sheets); sort out and remove the common names from one work sheet. How would i get this done with the least effort possible? Kindly help! ... 8 Apr 2010 05:05