Two Problems

[BOOGIEMAN]

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 ?

 

[Don Guillett]

pls do NOT multipost. See ans in your other post

 

[BOOGIEMAN]

pls do NOT multipost. See ans in your other post

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

 

[Don Guillett]

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.

 

[BOOGIEMAN]

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