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

G

gs

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?
 
T

Tom Ogilvy

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


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top