Two Problems

  • Thread starter Thread starter BOOGIEMAN
  • Start date Start date
B

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 ?
 
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.
 
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.
Click to expand...

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