Formula for sum of values in columns of other sheets per collaborator. Cells assigned to "nn".

Hi Gerardo,

To do sum in the Summary fields in the same sheet, you can use the SUMIF function:

=SUMIF(Assignado:Assignado, FIND("Enrique", @cell) > 0, NETO:NETO)

To do this from another sheet, you will have to insert the cell Reference, so

When you type in this formula

=SUMIF(

After that bracket you will see an popup with option showing "Insert Reference", click on that, select your sheet which has the "Assignado" column and then just select that whole range.

After inserting Reference it would look something like this:

=SUMIF({ADMIN_2020 Cell linking range 3}

Now just include the same Find formula which I mentioned at the top, so formula becomes:

=SUMIF({ADMIN_2020 Cell linking range 3}, FIND("Enrique", @cell) > 0,

Now we will need to define the range that we need to SUM, so as your SUM range is in different sheet, we will again have to use the sheet reference at the end, so it will look something like:

=SUMIF({ADMIN_2020 Cell linking range 3}, FIND("Enrique", @cell) > 0, {ADMIN_2020 Cell linking range 9})

NOTE: Do not copy this cell linking formula, as it looks you may have some column hidden so my range would be different, just go through steps and I hope it helps!

Thanks,

Jayesh