Hi Saliha,

Your question isn't clear, sorry. First, I'm not sure what cells contain the manual calculation you wish to automate. Second, I can't see how the Qty figures in cells B21:B26 are derived. Third, I don't know what the calculation is that you're wanting to automate. 

Mynda

Hi Mynda

I have updated file can you please give me result.

Regards/Saliha

Hi Saliha,

Thanks for providing a clear example.

Excel can't easily count based on a cell colour. You're best to put the size data in an adjacent cell so you can use the COUNTIF function. If you can't do that then you'll need to use VBA to count cells based on colours.

Mynda