Add up colored cells.

[getunursleep]

OK, all I'm trying to do is add up the green cells. To easy right? Not really. In the attached file you'll see sheet1 has the fomula I want and sheet2 has the colored cells. Thanks.

[zbor]

You'll need VBA for that.

But hey, this is the way how you can avoid it. By filter.

[getunursleep]

"I can't open .xlsx I'm running 2007"

I got it open.

OK, how would I do it with VB then?

Thanks.

[zbor]

xlsx is for 2007 (which you have uploaded in the first post).

Also, this solution is not possible for prior 2007.

[getunursleep]

I got it open.

OK, how would I do it with VB then?

Thanks.

[getunursleep]

OK, I got it to do what I wanted, but it takes a long time to calculate. Any ideas why? The new file is attached. Thanks