I sure hope this works!

You helped me in this post:
Help with Nested Range counts - microsoft.public.excel.worksheet.functions
posted 8/21/08

Can you see if you can help me in this post:
Mix/Max/Avg Help based on dynamic ranges -
microsoft.public.excel.worksheet.functions posted 8/26/08

I'm desparate, I can't figure out the syntax and can't figure out why
sumproduct is not working either, even though I tried what was already
posted. I've already determined I can't fix it, so it doesn't hurt to post
this. My project is at a complete halt until I can get this working OR will
have to analyze the data in a less automated fahsion which is just as bad.

--
Hile