how to sum a range depend if the corresponding adjacent cell has a specific string
 

for example
1 B C D E
2 ######## 22:41:08 stored,
3 ######## 22:41:09 $[*!20603,,14,+3]Intellex$[$u]
4 File $[1]F:\Inte.. compare
5 File $[1]F:\Intell. compare
6 ######## 22:48:11 execution
7 Completed: 13922 2.3
8 Performance: 323.2 (324.4
9 Duration: 00:14:52 idle/loading/preparing)
10
11
12 ######## 22:48:11 $[*!20603,,14,+3]ISGEdm$[$u]
13 ######## 22:57:49 stored,
14 ######## 22:57:50 $[*!20603,,14,+3]ISGEdm$[$u]
15 File $[1]F:\ISGEd. compare
16 File $[1]F:\ISGEdm\. compare
17 ######## 23:03:48 execution
18 Completed: 14680 2.5
28602 4.8

I want to calculate totals for columns C and E only for rows with Completed
in column B

Is there a range function and if something to include in the formula? or do
I have to create a couple of calculated columns to sum from?

how to sum a range depend if the corresponding adjacent cell has a specific string
 

=sumproduct(--(B2:B18="Completed:"),C2:C18)


=sumproduct(--(B2:B18="Completed:"),E2:E18)

--
Regards,
Tom Ogilvy


"gs" wrote in message
...
for example
1 B C D E
2 ######## 22:41:08 stored,
3 ######## 22:41:09 $[*!20603,,14,+3]Intellex$[$u]
4 File $[1]F:\Inte.. compare
5 File $[1]F:\Intell. compare
6 ######## 22:48:11 execution
7 Completed: 13922 2.3
8 Performance: 323.2 (324.4
9 Duration: 00:14:52 idle/loading/preparing)
10
11
12 ######## 22:48:11 $[*!20603,,14,+3]ISGEdm$[$u]
13 ######## 22:57:49 stored,
14 ######## 22:57:50 $[*!20603,,14,+3]ISGEdm$[$u]
15 File $[1]F:\ISGEd. compare
16 File $[1]F:\ISGEdm\. compare
17 ######## 23:03:48 execution
18 Completed: 14680 2.5
28602 4.8

I want to calculate totals for columns C and E only for rows with
Completed in column B

Is there a range function and if something to include in the formula? or
do I have to create a couple of calculated columns to sum from?