Forum Discussion
selecting certain cells to search for a name if the condition for the row exists.
Hi there i am a basic excel user and have hit a major hurdle creating a summary sheet of occurrence's for people. I have 31 sheets which are identical as below, and if a condition on any of the rows...
The attached sample file uses SUMPRODUCT to return the intended result. I'd recommend never working with merged cells and therefore the sample doesn't contain merged cells.