selecting certain cells to search for a name if the condition for the row exists.

[miket66]

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 for colum E contains the Liv i need a summary sheet to check the name cells further along the row to see if the persons name exists. If so i need this to be added together for all the sheets  for a monthly figure.

Hope this explains what i mean.

I use the countif function for other set area's in the sheet and that works fine as id does not require any specific condition to be met before checking.

Any help on this would be greatly appreciated,  Thanks in advance Mike.

[#2]

@miket66 

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.