I need alot more help...

TiggerToo · Mar 8th, 2002, 12:41 PM

In block c6 to c9 I have one date,
In block e6 to e9 the total is 8.
In block f6 to f9 I am looking for one of three codes.
What formula do you use when you need to look at c6 to c9 for the date.
look at e6 to e9 for the hours to total 8.
look for one of the three codes in the same blocks, for only one block.

I tried countif and it did not help. Anymore ideas.
I can e-mail a part copy of the project I am working on, to see if you all can improve on my personal project.

Barrie Davidson · Mar 8th, 2002, 12:51 PM

Quote:

On 2002-03-08 11:41, TiggerToo wrote:
In block c6 to c9 I have one date,
In block e6 to e9 the total is 8.
In block f6 to f9 I am looking for one of three codes.
What formula do you use when you need to look at c6 to c9 for the date.
look at e6 to e9 for the hours to total 8.
look for one of the three codes in the same blocks, for only one block.

I tried countif and it did not help. Anymore ideas.
I can e-mail a part copy of the project I am working on, to see if you all can improve on my personal project.

Are you looking to determine if C6 is a certain data AND E6 is 8 AND F6 is one of three codes? And then do the same for row 7, 8 and 9?

TiggerToo · Mar 8th, 2002, 07:33 PM

Barry,
I need all the help I can get with this project I took on myself, because I did not know if the timekeepers would keep my time straight. So I started making a form that I thought would be simple, but NOT.
If you or anyone would be so kind and look at my past posting, I would deeply be app...
or if you want me to e-mail you a copy. I could
Thank alot,
Walter

Barrie Davidson · Mar 9th, 2002, 08:34 AM

Quote:

On 2002-03-08 18:33, TiggerToo wrote:
Barry,
I need all the help I can get with this project I took on myself, because I did not know if the timekeepers would keep my time straight. So I started making a form that I thought would be simple, but NOT.
If you or anyone would be so kind and look at my past posting, I would deeply be app...
or if you want me to e-mail you a copy. I could
Thank alot,
Walter

Walter, go ahead and e-mail me a copy of your spreadsheet. Please include a concise description of your requirements.

Regards,

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 8th, 2002, 12:41 PM	#1
TiggerToo Board Regular Join Date: Feb 2002 Location: Macon, Georgia USA Posts: 124	In block c6 to c9 I have one date, In block e6 to e9 the total is 8. In block f6 to f9 I am looking for one of three codes. What formula do you use when you need to look at c6 to c9 for the date. look at e6 to e9 for the hours to total 8. look for one of the three codes in the same blocks, for only one block. I tried countif and it did not help. Anymore ideas. I can e-mail a part copy of the project I am working on, to see if you all can improve on my personal project.

Mar 8th, 2002, 07:33 PM	#3
TiggerToo Board Regular Join Date: Feb 2002 Location: Macon, Georgia USA Posts: 124	Barry, I need all the help I can get with this project I took on myself, because I did not know if the timekeepers would keep my time straight. So I started making a form that I thought would be simple, but NOT. If you or anyone would be so kind and look at my past posting, I would deeply be app... or if you want me to e-mail you a copy. I could Thank alot, Walter