Hmm. Not sure why you're not getting any numbers. This thread has HTML turned off, so I had to just make a table, but I assure you, it works on my test sheet. I assume your version of Excel has AGGREGATE? I'll have to cogitate a bit to see if I can think of any other reasons.