Hey,



I have a workbook with 365 sheets, as they are 1 for each day of the year, as youve probably guessed.

C1 in each sheet contains the day of the week, and each sheet contains the amount of clients we delivered to that day.

I am now trying to see which day of the week is the busiest, so i have the below formula for counting the occurrences of each day.



=SUMPRODUCT(COUNTIF(INDIRECT("'"&$A$1:$A$365&"'!C1"),G2))



G2 being the master sheets day of the week, so the next one, Tuesday, is in G3 etc.



The A Column is the name of every sheet as i read that that was the best way to do that part.



I now need to count how many Sales order numbers appear in each worksheet that contains each day of the week, the SO numbers will start in C4 and end at the next blank row.



Will this be a nested countif and if so, can someone help me put that together.



If not, a macro that does the same job would be much appreciated.



Cheers