Home » Forums » Open Source Learning Center » Question and Answer

Find text inside cells and sum their data

Submitted by Rachel135 on 17 October, 2012 - 11:54

Hi,

I need to sum process time in every row the process name appears. In some cells multiple process names appear. I used SUMPRODUCT formula, but it did not find the text in cells that contain multiple product names.

Process total time

Process A 91
Process B 32

formula in cell "91" is:
=SUMPRODUCT((B18:B23=A2)*(C18:C23))

B18:23 C18:C23
Process Time
Process A 60
Process A, Process B, Process C 50
Process A, Process B, Process C 40
Process B, Process C, Process A 30
Process A 31
Process B 32

The formula only added to the sum the 60 and 31 although Process A appears in more rows.

Any idea?

Thanks a lot.

Rachel

‹ Excel-getting the extreme values of a data group macro to auto email multiple files ›
»

RE: Find text inside cells and sum their data

Submitted by manny on 17 October, 2012 - 13:54.

Hi,

Here's another solution. Change your formula with the following one:

 = SUMIF($B$18:$B$23, "*" & A2 & "*", $C$18:$C$23)

 

Best regards.

»

Thanks! it works :)

Submitted by Rachel135 on 17 October, 2012 - 20:15.

Thanks! it works :)

»
Nick's picture

you need this : Process A,

Submitted by Nick on 17 October, 2012 - 12:15.

you need this :
Process A, Process B, Process C 50

to be this:

Process A 50
Process B 50
Process C 50

or it won't work

»

Thanks for the advice

Submitted by Rachel135 on 17 October, 2012 - 20:16.

:)

»