I am trying to produce calculations for a sheet , broken down by month where
I want to use contain somehow with sumproduct or countif but having no joy.
Any help would be appreciated.  The 2 formulas I have tried are:
=SUMPRODUCT(--($A$2:$A$573="Aug*"),--($D$2:$D$573="App*") ...

I have data that I've copied and the data within the spreadsheet is within 2
columns. The first column repeats the headers while the second column has the
data
For example

Hi guys, looking for a bit of help here. What I want is to have a cell,
let's say it's A1, have a drop down menu within it. No proble, I got that
part all figured out.
Then I want another cell, let's say B1in which is entered a numerical value.

I'm new to these parts and I'm hoping someone can help me. I have a simple
email list of 4000 addresses (List A) and some are no good. I've made a
separate list (List B) of those and want to delete all of them from the
initial list (List A). Is there a way of doing this without ...

I am currently using the MAX command to find a maximum value within 96
columns per row.
I display the result in a column to the left of the 96 columns containing
the searchable data.

I have recorded this macro to sort a list of names up to 45 names. Not all
the names are written.
Private Sub CommandButton5_Click()
       Range("B14:FQ58").Select

I know how to use conditional formatting to change the text color in a
cell.  But I'm at a loss as to how to make a cell "fill" with a color.
It must be something simple.

I have a computer with 2gigs memory and over 3Ghz cpu, but when I have a
70mb spreadsheet open and I then try to simultaneously open a 50mb
speadsheet I get a window message that says I do not have the available
resources to do so.  Might this be an excel limit, or something ...

Purpose: total miles that were driven last night in co. vehicles.  i.e. when
they left the parking lot and when they came back the next morning.
Problem: the formula =SUM(('Mileage Log'!E12-'Mileage Log'!E10) >0) gives me
a true (1) false (0) answer.  I want it to exclude ...

In column A I have a worksheet that can have rows from 2 to 200 or more
depending upon the workbook. Row 1 is headers.  The data will be "SS_11" in
row 2  "SS_12" in row 3 etc.   What I want to do is to have a command button
to slightly change the data to add a prefix depending ...

I'd office 2007 installed on XP machine. The font (type: times, size:9) in
Excel 2007 is not as sharp as Excel 2003. Besides alpha is sharper than
numeric. Any ideas to solve the problem?

I am trying to think of a formula that will give me the result that I would
like:
Example
Sheet 1

How do I calculate the z factor automatically by using Hall-Yarborogh equation without changing (Y) every time to reach F=0 ?
if any body know .please answer me.
Thank you very much
khalid

column of sale prices in dollar amounts.

I want to use the group and outline functionality to group sets of
rows, but instead of the bottom row of the group showing when I
collapse the group, I want the top row to show.  This is because each
of the items below the top row are the elements of the group and the