Count cell matching colour with row and column criteria

[Arun Mani A]

Hi,

I am preparing the chart with types of windows at various levels. The cells are coloured with green colour is fixed, purple colour is supplied, blue colour is frame fixed and where colour not done is not supplied.

I have used VB-macro zcountif which counts nos of windows fixed.

Please help out with formula for getting details of windows fixed level wise.

Attached is the sample excel.

Thanks in advance.

Regards

Arun Mani A

 

[bosco_yip]

See attached file

Regards
Bosco

 

[Arun Mani A]

Thanks dear Bosco

 

[Arun Mani A]

Hi, Thanks this sheet worked, but a new requirement came for counting Sold and Unsold frames and fixed.

 

[bosco_yip]

Hi, Thanks this sheet worked, but a new requirement came for counting Sold and Unsold frames and fixed.

1] Check A28 dropdown list for selection of "sold" and "unsold".

2] See revised file attached for the new requirement.

Regards

 

[Arun Mani A]

Dear Bosco,

Attached is the file where the count is coming less, attached is the sheet for reference. I have changed the Sold & Level details, the count is not matching.

Please help out.

 

[bosco_yip]

Dear Bosco,

Attached is the file where the count is coming less, attached is the sheet for reference. I have changed the Sold & Level details, the count is not matching.

Please help out.

Based on your attached file, the counting is checked and satisfied by me.

Please specify where are the counting not matching as stated ??

Regards
Bosco

 

[Arun Mani A]

Hi the count of Children Room - GD-01 for Unsold in Level 2 is 2 nos, for the formula in cell c32 gives result 1 nos.

Regards