Two Problems
 

A B C D E F

02/11/04 042110*** 10:39:53 am 10:47:40 am 467 4
02/11/04 035564*** 11:21:47 am 11:22:10 am 23 1
02/11/04 035564*** 11:55:05 am 11:56:12 am 67 1
02/11/04 042110*** 05:27:28 pm 06:14:08 pm 2800 24
02/11/04 563*** 09:06:52 pm 09:07:35 pm 43 1
02/11/04 042110*** 09:09:02 pm 09:22:46 pm 824 4
02/11/04 042110*** 09:37:37 pm 10:43:39 pm 3962 17
02/11/04 568*** 09:43:30 pm 09:53:22 pm 592 3
02/11/04 042110*** 11:37:28 pm 12:34:18 am 3410 15
03/11/04 042110*** 12:40:50 am 01:01:56 am 1266 6
03/11/04 0641217*** 08:05:57 am 08:06:18 am 21 11
03/11/04 563*** 09:31:06 am 09:32:33 am 87 1
03/11/04 471*** 09:47:48 am 09:47:48 am 0 1


Simple one :
1. How do I calculate sum from F 7 to F 350 (f7+f8+f9+...+f349+f350) ?

Hard one :
2. I need to calculate sum of column F values only if in column B (in the
same row) is value 042110***
In my example above that would be : 4 + 24 + 4 + 17 + 15 + 6

I'm trying to accomplish that in Open Office,
I guess that's the same as in MS Excel ?

Two Problems
 

pls do NOT multipost. See ans in your other post

--
Don Guillett
SalesAid Software

"BOOGIEMAN" wrote in message
...
A B C D E F

02/11/04 042110*** 10:39:53 am 10:47:40 am 467 4
02/11/04 035564*** 11:21:47 am 11:22:10 am 23 1
02/11/04 035564*** 11:55:05 am 11:56:12 am 67 1
02/11/04 042110*** 05:27:28 pm 06:14:08 pm 2800 24
02/11/04 563*** 09:06:52 pm 09:07:35 pm 43 1
02/11/04 042110*** 09:09:02 pm 09:22:46 pm 824 4
02/11/04 042110*** 09:37:37 pm 10:43:39 pm 3962 17
02/11/04 568*** 09:43:30 pm 09:53:22 pm 592 3
02/11/04 042110*** 11:37:28 pm 12:34:18 am 3410 15
03/11/04 042110*** 12:40:50 am 01:01:56 am 1266 6
03/11/04 0641217*** 08:05:57 am 08:06:18 am 21 11
03/11/04 563*** 09:31:06 am 09:32:33 am 87 1
03/11/04 471*** 09:47:48 am 09:47:48 am 0 1


Simple one :
1. How do I calculate sum from F 7 to F 350 (f7+f8+f9+...+f349+f350) ?

Hard one :
2. I need to calculate sum of column F values only if in column B (in the
same row) is value 042110***
In my example above that would be : 4 + 24 + 4 + 17 + 15 + 6

I'm trying to accomplish that in Open Office,
I guess that's the same as in MS Excel ?

Two Problems
 

On Wed, 1 Dec 2004 11:06:35 -0600, Don Guillett wrote:

pls do NOT multipost. See ans in your other post

OK, sorry, I wasn't sure what's the right group for that question

Two Problems
 

If you do want to multipost suggest crossposting (send to both in the same
msg). That way all answers are seen in both and time and talent are not
wasted answering more than once. Of course, some answer anyway even if good
answers have been given. Why, I don't know.

--
Don Guillett
SalesAid Software

"BOOGIEMAN" wrote in message
...
On Wed, 1 Dec 2004 11:06:35 -0600, Don Guillett wrote:

pls do NOT multipost. See ans in your other post

OK, sorry, I wasn't sure what's the right group for that question

Two Problems
 

On Wed, 1 Dec 2004 12:12:24 -0600, Don Guillett wrote:

If you do want to multipost suggest crossposting (send to both in the same
msg). That way all answers are seen in both and time and talent are not
wasted answering more than once. Of course, some answer anyway even if good
answers have been given. Why, I don't know.

No, I never did that, I thought that's spaming