I just noticed something...
The section from row 13 to 27 seems to be a summary area where the OT is
also entered. The entry on row 15 seems to correspond to the entery on row
9.
If this is the case then you can just base your sum on the data in rows 13
to 27.
--
Biff
Microsoft Excel MVP
"T. Valko" wrote in message
...
On rows 9,10 and 11 - when there is an entry will it *ALWAYS* be a number
and *ONE* letter? for example:
It *ALWAYS* be
2c...2c...4c...<empty...10c
It will *NEVER* be:
2c...2...4c...<empty...10
--
Biff
Microsoft Excel MVP
"Wayne" wrote in message
...
Okay I have removed the 2 functions and will place the file on
savefile.com
(waiting on the activation link) I also place the file here,
http://www.thez4.com/FileShare/book2.xls
Once you open the spreadsheet you will see the top area is the timesheet
area. I just spoke with the mgr who is going to be using the timesheet
and
she explained that the letters indicate the type of OT IE: C=Comp Time :
O=Straight OT : S=Stby etc. Column R is the totals column. Rows 9,10 & 11
Columns C:I & K:Q will be the only rows where text will ever appear in a
cell
and need to be totaled. Row 6 will just have straight hours and therefore
doesn't need any modification. They should have presented this info in
the
first place and
T.Valko recommended changing the format of the spreadsheet, that was the
first question I asked but they have been using this format for some time
and
don't want to change it.
I wish to extend my thanks for everyone who has offered to help me.
PS it's been like ten minutes and I still don't have the email so I will
post the link once I get it.
Wayne
"Gord Dibben" wrote:
Wayne
You can post the workbook at one of the hosting sites below.
http://www.freefilehosting.net/
http://savefile.com/
When you have uploaded to that site, post the URL so we could download.
Gord Dibben MS Excel MVP
On Fri, 22 Feb 2008 19:54:01 -0800, Wayne
wrote:
Ron,
Can I post files here? I can post the spread sheet that would show
exactly
what I am attempting to do. I am using MS Office 2007 Pro.
Thanks
"Ron Rosenfeld" wrote:
On Fri, 22 Feb 2008 19:09:00 -0800, Wayne
wrote:
Okay Thanks to both of you, unfortunately I can't seem to get either
option
to work. I am weak in this area of Excel. I get the function entered
okay,
just keep getting reference errors. For Gords I get a #VALUE! Error
if I
attempt to reference more than one cell. In my example I should have
stated
that this is a time sheet therefore I need to sum up K1 to K9. For
Rons in
the same case I get a Function not valid error.
In your original post you indicated the string was in "a" cell,
implying one
cell. That is how my function is designed to work. It is NOT
designed to work
over a multicell reference. But it will work not only on the example
you gave,
but also on examples like 14.63CDE + 0.478ABC (again all in one
cell).
If you have mixed-text and numbers in K1:K9, you should be able to
enter my
function in an adjacent column in the form =EvalNums(K1) and fill
down to K9;
then SUM that column.
Or you could provide more specific information about your data.
Also, I've not seen a "Function not Valid" error. Where do you see
that? What
version of Excel?
In mine, when I select multiple cells, I get a #VALUE! error in the
worksheet
cell with the formula.
--ron