Every day I get a spreadsheet of info for all members of the company. Its broken down by employee, then the store that the employee worked in. The problem is, the cells with the employee name is merged so I can’t just sumif the name is right. So I need to sumif for the name, then the empty cells below it until there’s another name.
Name 1 Store 1 4 Store 2 5 Store 3 2 Name 2 Store 1 3 Store 2 4
So what I’m trying to get is the total for Name 1, which in this example would be 11.