I've imported a file and I need to put the data in columns.  The data seems
merged.

In a calculated field in a pivot table, , this produces a #VALUE in
areas where in there is no(blank) data to calculate. (IOW, 'Total
Sales Item Amt' can have blanks.  Margin, in these instances is always
a negative number.

I want to use a function to determine how many bonus tickets I should give
out at the end of each month. One (1) ticket for every three (3) apples sold
and the number of bonus tickets are culmulative.
For example, here is a table:

Forthe past 6 months, I've been working on a single workbook for a large
project I'm doing.
About 3 or so months ago I noticed an error when I opened the workbook.
The error states that the workbook must be recovered due to a calculation

I want to use a function to determine how many bonus tickets I should give
out at the end of each month. One (1) ticket for every three (3) apples sold.
For example, here is a table:
DATE      #APPLES SOLD    BONUS TICKETS              

Depending on the values in column U, I want column V to have a value.
I am using an IF formula for this.
There is one problem. Some cells in Column U (eg U26) are blank(have
no values). However if I user U26 ="" for testing the condition, this

I am using VBA to produce a quote worksheet with product descriptions in
column C and the product price in Column F.  I want to sum from Cell F6 to
the last product price which varies as products are added and removed from
the worksheet.  What formula can I put in the TOTAL cell ...

I would like to set up a spreadsheet to record staff leave.  My point o
departure is a calendar in a spreadsheet for 2008 for each employee.
Should the person be sick, I enter an S.  If he takes holiday leave,
enter an H etc. etc.  Below, or in another sheet/workbook, I will hav

hi, first of all i don't know if it's possible to do this with excel....
i have a liste wich have 4 colums
column 1  article number and name (AAA-305 - cli- a/c keeprite)
column 2  article selling price (500.00$)

Thanks to everyone earlier who responded to my Time and Date Entry question.  
I'm trying to get these two strings of code to work together in the Worksheet
Change area, but I'm not understanding why they won't.  
I'm trying to enter a date in column A (A1:A10000) and times in ...

Happy New Year, all.
I need to lookup based on both of two conditions being satisfied.
We have a number of financial advisers in regional offices, and they are
ranked.

I'd ,like to calculate the average of Machine 1 through 2 and Machine
5 through 11.
So the range is not in one piece.
Further error values have to be excluded.

I have a combo box with different months in. The user will select a
month then select a button to determine what report to run. I have 5
buttons for each month, so rather than have 60 buttons, I want to
select the Month, and then the user chooses the button.  I then want

I'm trying to add the amounts in a column where two other columns match the
set criteria, however, it is comparing the first cell only to the text
specified. Does anyone know how I overcome this or correct the formula below?
=IF(AND(Source!$A$2:$A$9999="X",Source!$C$1:$C$9999="Y") ...

Is it possible to create a formula based on the colour of a cell?
I'm trying to get automatically calculating cells on a holiday/sickness
database. Cells are yellow if holiday, brown if sick etc. So for the totals I
want the formula to + 1 for each yellow box and same for other ...