View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gs gs is offline
external usenet poster
 
Posts: 1
Default 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?