Hello everyone,
I have a spreadsheet with a column that I need to total. The stinker here is that the column will move to the right as we add data to it. I am hoping to have a formula that looks for all instances of a person's name in column B and when it finds that name then find the column titled "Number of Tests". Then add the rows that contain that person's name.
This might make it simpler to understand what I need...
Here is my formula for a fixed column.
=SUMIF('Data Dump'!B:B, "*Philip*", 'Data Dump'!E:E)
But instead of E:E, I need it to search for the column labeled "Number of Tests". If it helps, "Number of Tests" will always be in row 6.
I don't even know if this is possible. I appreciate any help you can give.
Thank, you,
Lea
I have a spreadsheet with a column that I need to total. The stinker here is that the column will move to the right as we add data to it. I am hoping to have a formula that looks for all instances of a person's name in column B and when it finds that name then find the column titled "Number of Tests". Then add the rows that contain that person's name.
This might make it simpler to understand what I need...
Here is my formula for a fixed column.
=SUMIF('Data Dump'!B:B, "*Philip*", 'Data Dump'!E:E)
But instead of E:E, I need it to search for the column labeled "Number of Tests". If it helps, "Number of Tests" will always be in row 6.
I don't even know if this is possible. I appreciate any help you can give.
Thank, you,
Lea