Hi,

Could someone please assist me with a formula? I need to count the number of items that have a certain colour in the first cell and data in another cell.

I need to count how many T1, T2, T3, T4, T5, B1, B2, B3, B4 and B5's are there in the different colour rows.

Could someone please assist me with a formula? I need to count the number of items that have a certain colour in the first cell and data in another cell.

I need to count how many T1, T2, T3, T4, T5, B1, B2, B3, B4 and B5's are there in the different colour rows.