I've got a spreadsheet with different names in a column, im trying to count the number of times a name occurs. So far I have worked out this formula - =SUMPRODUCT(LEN(D:D)-LEN(SUBSTITUTE(UPPER(D:D),UPPER(D3),"")))/LEN(D3) The name im looking for is in D3 and im looking to see how many times it occurs in the same column, with the column being D.
The bit im now stuck on is that its a weekly thing and ive got 4 different worksheets set up for each week. How do I count the number of occurrences in the 4 different sheets.
(The sheets are all identically set up, just different data in the columns.)
Thanks in advance
The bit im now stuck on is that its a weekly thing and ive got 4 different worksheets set up for each week. How do I count the number of occurrences in the 4 different sheets.
(The sheets are all identically set up, just different data in the columns.)
Thanks in advance