Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two Problems
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
aauugghhh...#div/o problems & various average formula problems | Excel Worksheet Functions | |||
Problems with MAX | Excel Worksheet Functions | |||
Tab key problems | Excel Discussion (Misc queries) | |||
Problems merging an excel file due to code or file problems? | Excel Programming | |||
VBA Problems | Excel Programming |