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 ?

 

[BOOGIEMAN]

This should be better :

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

 

[Don Guillett]

In excel, Have a look in HELP index for:
1. SUM =sum(f7:f350)
2. SUMIF =sumif(f7:f350, condition)

 

[Bernie Deitrick]

I'm trying to accomplish that in Open Office,
I guess that's the same as in MS Excel ?

No, actually, it isn't the same software, so Open Office may have completely
different functionality.

HTH,
Bernie
MS Excel MVP

 

[BOOGIEMAN]

In excel, Have a look in HELP index for:
1. SUM =sum(f7:f350)
2. SUMIF =sumif(f7:f350, condition)

Thank you very much !

 

[Don Guillett]

hope it helped

 

[BOOGIEMAN]

hope it helped

For question one completely but it seems I still can't
find solution for question two.
I did this :

=SUMIF(B7:B342;B22;F7:F342) //B22 cell value = 042110***
=SUMIF(B7:B342;"042110***";F7:F342)

But in both cases answer is = 0

I think it's because this formula searches value "042110***" in my F
column and that's not what I want. I want formula to calculate all F column
values wherever in my B column is value "042110***"
For example my B22, B25, B27, B28 ... cell values are "042110***"
I need to know sum of F22+F25+F27+F28+....

Can you halp me with this, I can send you my .xls document
if you have spare time.

 

[Don Guillett]

I just tested with xl2002 sp2 and both formulas worked just fine for
042110*** in column B and the numbers to sum in col F
b f
042110*** 10


=SUMIF(B7:B342,B22,F7:F342)
=SUMIF(B8:B343,"042110***",F8:F343)

Of course, in the US version I use commas instead of semicolons.
If necessary and your file is SMALL, send to my email below