To see it work in action, just download this example I made: SUMIF Multiple Sheets Example 1 file(s) 12.97 KB Download Source: MrExcel.com « Creating a list of unique values Show most / least used text in a range »
