LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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 ?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
aauugghhh...#div/o problems & various average formula problems acbel40 Excel Worksheet Functions 5 October 19th 09 05:00 PM
Problems with MAX Carlo Excel Worksheet Functions 6 September 5th 06 12:51 PM
Tab key problems jana Excel Discussion (Misc queries) 1 September 4th 06 12:33 AM
Problems merging an excel file due to code or file problems? Cindy M -WordMVP- Excel Programming 0 September 14th 04 02:58 PM
VBA Problems Stromma[_3_] Excel Programming 1 February 25th 04 05:46 PM


All times are GMT +1. The time now is 08:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"