smilinglilies
New Member
- Joined
- Jan 25, 2019
- Messages
- 9
Hi
I am currently trying to create a formula to count the number of cells of a certain colour that is a certain criteria.
I'm looking for something like a countcolorif function but can't work it out and I'm getting frustrated that I can't work this out!
Basic version below of spreadsheet. (Cells are coloured instead of typed in)
How do I write a formula that will count the number of orange cells in the rows that have a 2 in the first column?
<tbody>
</tbody>
I know I can do this by countcolour () + countcolour() but I was wondering if there is a different and not as long winded way of doing it?
Any help and advice is greatly appreciated.
I am currently trying to create a formula to count the number of cells of a certain colour that is a certain criteria.
I'm looking for something like a countcolorif function but can't work it out and I'm getting frustrated that I can't work this out!
Basic version below of spreadsheet. (Cells are coloured instead of typed in)
How do I write a formula that will count the number of orange cells in the rows that have a 2 in the first column?
No Bedrooms | |||
2 | orange | grey | blue |
2 | blue | orange | grey |
3 | blue | grey | orange |
3 | blue | grey | orange |
2 | grey | blue | grey |
<tbody>
</tbody>
I know I can do this by countcolour () + countcolour() but I was wondering if there is a different and not as long winded way of doing it?
Any help and advice is greatly appreciated.