Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |