Hi

I want to use the sumif function to sum the hour used for training at specific processes. My problem is when I export it from the software to Excel the process is presented with a number before the description of the process in the same cell.

It is possible to set up the function to sum if the Reference cell is Equal to a part of the cell. I have to use a Reference cell because of the amount of processes.

Instead of using =SUMIF($K10:$U82;"*Training1";$AB10:$AB82) where "*Training1" will summarize every cell that Training1 is the part of the cell contain, I want to use =SUMIF($K10:$U82;BY7;$AB10:$AB82) where BY7 is a cell reference. I can't put *cell reference like *BY7 in the function, it is other ways to do it?