Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count specific text only if adjacent cell is blank? | Excel Discussion (Misc queries) | |||
Sum only specific cells based on value in adjacent cell | Excel Discussion (Misc queries) | |||
Fing a specific string in a Cell | Excel Discussion (Misc queries) | |||
Find a specific string in a cell | Excel Programming | |||
Counting a specific number only if an adjacent cell has something | Excel Discussion (Misc queries) |