I would like to count the number of date cells in a range with a specific
year. For instance, I would like to do
COUNTIF(cell range, year(current cell) = 2007)

I am having trouble creating an Excel chart that has a single set of columns
on the Y axis and multimple lines on the x axis.  As I recall, Jon Peltier
gave me a great way to force the chart wizard  which I did not,
unfortunately, keep.  I am working on a chart that will have 6 ...

I have a spreadsheet which contains a drop down box that has different lead
sources (Phone Book, Internet, Postcard Mailer, etc)
The x-axis should have the lead source type (found in [table column 1]), and
the y-axis should have the number of times that lead source was found in

Is there a way to have excel graph a function? I am thinking of my graphing
calculator from high school (x=2y).
I would like to have excel graph a forumal I have created with a starting
value of 0% and a max value of 100% so that I can see econimcal value. I need

Is there such a thing as "F4" a range?

Hi! I've got multiple indiv. company worksheets, a summary worksheet, and a
"lookup worksheet" that lists reps, mgrs, and codes. Currently, the cells of
the summary worksheet are linked to each of the indiv. company sheets. Each
code on the company worksheets is included on the ...

When I click on a cell in Excel linked to a cell in another tab, i am brought
straight to the source of the data. My work computer won't do that. I checked
all of the excel options i have and it's not obvious to me how to get this
function to work.

How can I conditionally format a cell based on the value in a different cell.
I have two columns of information. None of the information in the cells I am
trying to format is numeric. I am trying to track names to loans that are
with the company. If they wrote outside, I need to ...

(Using Excel 2007)
I have a column of numbers in a sequence, for example 1,2,3 up to 10.
If for example I merge the two cells with 5 & 6 in them, the 6 is lost and
the sequence is broken.

After importing data into excel, I have the need to insert blank lines after
each data line to make the data easier to work with.  I have been doing it
manually, but it takes a long time on big spreadsheets.  Is there a way to
have excel insert a blank line after each data line ...

I built a spread sheet that has text in one cell and more text in a second
cell. There are 200 rows of data like this. How do I link these cells so that
they always stay together?
In other words, if I sorted by alphabet I want the second cell to follow.

I hope somebody can please help asap.  I have a huge computer
programming exam tomorrow and I do not understand how to use the redim
statement with dynamic arrays or how to call a subroutine.  I have to
know how to do both by tomorrow.  Could sombody please break it down

I have the following array formula (Excel 2003) in a cell:
=AVERAGE(IF(WEEKDAY(Seven)=WEEKDAY($B283),$B$3:$B$262))&" per
"&TEXT($B283,"dddd")
where "Seven" is a named range for all the days in the year 2007 & column B

We're having an issue with exporting data from Infomaker 9 to Excel
format.  We did not encounter this issue until we recently applied
Service Pack 3 for Office 2003.  Infomaker 9 allows us to export to
"Excel 5 with headers" or "Excel with headers".  When we export to

When I copy a worksheet into a new worksheet, the columns, rows, fonts etc do
not remain the same as the original format which causes us to have to
manually resize the new worksheet to match the existing one. Does anyone have
a solution? thanks