I am trying to count conditional data that is true in 2 columns.  Such as If
column = green and column b = south then count it.  I need it to go through
about 100 rows of data and have it tell me how many times I get a true on
both conditions.  Any ideas?  I have tried nesting an ...

First, thank you for the help. I'm not sure how to ask this but I'll try.
When one of my co-workers opens a cell to edit containing a formula Excel
takes him to the worksheet and cell referenced first within the formula. How
does Excel do this? Is there something within ...

i get the pound sign in some cells not what i insert, in some it shows right
in the formula bar ,some it only shows the formula

I want to replace all the occurences of a particular character sequence in a
workbook containing 256 worksheets.  Is this possible

How can I TRIM i.e. remove the first 3 numbers in a column of data (all
rows) if the leading 3 numbers are 123, and replace them with 9
so for example: if my existing number is 123987654 replace with 9987654
Thanks

Hello all. I am still trying to get this timesheet where I want it.
This is where I am at:
I have a cell that mentions the year (G7) and the sheet mentions the
pay period beginning (ex: January 1).

Collumn A has a selection of dates
i.e
1/3/2005
2/3/2005

I am working with a spreadsheet that has an operating margin and a planned
operating margin and some months I have a postive OM and some months a
negative OM but when I display the variance between the two I'd like to
display the variance as just a number, but automatic formating ...

can anyone tell me why this formula works
=IF(AND(G7<(TODAY()-15),I7=TRUE),"OK","contract required")
but this one doesn't
=IF(AND(G7<(TODAY()-15),I7=yes),"OK","contract required")

I want to make a croos section between two columns on a third column.
Actualy, I have two colums, first one containing a lists of numbers from 1 to
2000 and a second column with 700 numbers from the same range (i.e. 1, 4 ,17,
22, 23 ...). I need a third column that has the ...

When using Vlookup and there is no direct match the response is "#N/A",
telling me that there is no value in the lookup table.  The problem is that I
have to sum the results of the lookup function. Since some of the values are
"#N/A" the sum of the column is "#N/A".  How can I ...

SCENARIO
I have an Excel sheet which contains dates in row 1 and the corresponding
days in row 2. The days are derived using formulas. For instance, B1 carries
the date 26 June 2006 and had been formatted to display 26. B2 = B1, and had

How can I convert 7:00 PM (or 0.791666666666667) to 1900 (this has a general
format)
My problem is that I import a database from MS Access and its time format is
as the example above shows. Thus I'm looking for a formula that can convert

I'm trying to create a questionnaire where there are 3 possible responses to
each question, each wtih a different value, but where the respondants can
only give one answer per question. I've set it up using the checkboxes from a
formula toolbar at this point. Would anyone be able ...

I need help to perform this action:
1. When User check the box, it will hide column B(for instance) in
another sheet (for instance, output sheet)
2. When User uncheck the box, it will unhide the column B that User had