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.

​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.  Read More

​