I am wanting to sumif a series of date times in a colum and sum another colum
with $ values
eg
         A                          B

Using Office 2007, where is "FIND"? Use to be under EDIT.

This problem is giving me a headache!  I am struggling with
how best to set up a workbook to track various transactions
in a mutual fund.
Does anyone have a good design for that?

I have a mission I need help finding a good way to start.  I am working with
excel 2003.
What I am working with is:
1)  a survey of about 100 sheets

how do i track 6000 raffle tickets in intervals of 10. There has to be a
formula rather than entering the numbers in manually!

Is there a formula to add the sum of all highlighted cells only in a column
with both no fill and highlighted cells.

Thanks in advance.
My pivot table needs to be refreshed every time when new data come.
I set up a dynamic data source using OFFSET as follow:
=OFFSET(Data!$A$1,0,0,COUNTA(Data!$A:$A),COUNTA(Data!$1:$1))

I have a client that opens a file in excel. We are unable to view the file in
normal view. We can see the file is we go to print preview or full screen
mode. How can i change it to view in normal screen mode?

I have a spreadsheet that contains over 6,000 lines and 20 columns.  The
spreadsheet changes often.  Each of these columns may have "0", "-", "0.00%",
"call desk" etc.  Instead of manually recording the macros to delete these
specific values for each column, is there a code to do ...

I have print areas in 4 separate worksheets. Using Ctrl + select sheets, then
print to Adobe Acrobat results in 4 separate files. Adobe wants a new file
name at the outset of printing each area. Is there any way to print these
areas to one PDF file?

Is there someone who can recover my ms excel corrupted file?Please
help me guys!..I know theres an expert for this..I try to search all
softwares recovery program in ipmart-forum but i couldn't find
anything. I would be thankful and appreciate if there is someone that

I am running into a problem where my Vlookup function is not finding certain
data from the table it is referenced to.  I'm using the formula
=IF(OR(Z23="",Z25="",Z26=""),"",Z26/(Z23*(VLOOKUP(Z25,'Op
Speed'!$A3:$D18,4)*60))).

I want to start a new worksheet with the ending data from my old
worksheet.  I'll continue to enter data into the old worksheet, but I
want it to copy into the new one as well.
I tried using sheet1!F384 for example, but all that does is put in the

It's a new computer with 512mb of ram, and it opens easily on my other
older computers. Any idea why this newer operating system will not
open larger excel files?