I have an Excel worksheet with six separate columns of numbers and several
rows with numbers in one, several or all of the columns plus a total column.
I am using a formula to crosscheck the totals.  The formula being used is
=IF(SUM(S4:S22)=SUM(B23:Q23),SUM(S4:S22),value). All of ...

Hi, I have values in a cell that changes if the cell next to it changes.
The values are five constant values, i.e. "Critical Criteria", "Non-Critical
Criteria" etc.
I need to colour the cell a different colour based on each unique value.

I have two columns with dates in my dataset, which define
the start and end dates for a certain event. For each
observation in the dataset, I'd like to count the
number of other observations in the dataset that

I have a range of dates such as:
3/19/2003
3/20/2003
3/20/2003

Is there any way to turn off the iferror function in Excel 2007? The new
function has wrecked havoc on our receipt of client excel files. We receive
client files that contain 3rd party custom code where the authors created
their own iferror logic. The code is protected and ...

I'm using the following in another cell which works fine.  
=SUMPRODUCT (($A$4:$A$300=36)*($B$4:$B$300="SALE")*($G$4:$G$300="Rob"))
I'm trying to create another formula where column A has group numbers,
column C has dates, column X has costs...I need to sum all cost where columns

I have a spreadsheet that has a column containing date, time and other info I
don't need.  (Ex: 12/13/2006 01:07 PM    3,695,666 Travis Tritt).  Its a
musical listing imported from a directory.  I want to delete everything
except for the final text (from the example "Travis ...

1) Is there a way to create a hyperlink that just references the sheet
and cell you want to jump to within the same workbook? i.e.:
'sheet1'!A1
When I go through the "add hyperlink" option and choose "place in

Thanks to T. Valko and JMB who answered my prior question on the same
subject but I'm afraid I left out a couple of significant details.
My renewed question. I'm using Excel 2003 and know how to use arrays--up to
a point.

For example, I have three columns as follows:
     A        B       C
1    100    120
2    100     80

I have tried and tried.
If you look at the cost of these two plans there is a 13-14% increase
Plan 2006 rates
Employee 345.31

I am using the Ctrl F command to search through a 3,000 row
spreadsheet to locate a string of data. I am getting an error message
indicating "Microsoft Excel cannot locate the data you are search for"
However when I page through the data I find it in different cells.

Hello, I need to write a formula that sums totals from different sheets but,
I want it to ignore the negative numbers and add only the positive #'s
this is what I currently have
=SUM('week-1:Week-5'!K12)

this morning i tried to work on my worksheets using excel but for some reason
i could not edit any of the sheets that i had saved in the past.  i have no
problem viewing them.  what can i do to solve this problem. thank you.

Insert new info on source workbook  that is linked without having to change
all the link locations on the destination workbook  that it is linked to