Can you tell me how to email you the file so you can see it? Then you'll see
what I did and how to make it easier using the sumproduct for when I do this
sort of thing in the future?

"Fred Smith" wrote:

We've sure been beating around the bush if all you want to do is sum a
column. Solutions to this problem are easily found.

What column do you want to sum? What are the conditions that need to be met?
What version of Excel do you have?

Regards,
Fred