JazzSP8
Well-known Member
- Joined
- Sep 30, 2005
- Messages
- 1,227
- Office Version
- 2013
- 2010
- Platform
- Windows
Hey All
I need an Excel 2013 formula to find the count of how many times a value appears in a column, with a unique value in another column - For example;
If I wanted to count 'Bathroom' then it would return 2 and for Kitchen it would return 1.
I've been messing around with COUNTIFS but can't seem to get it to work.
Can anyone help?
I need an Excel 2013 formula to find the count of how many times a value appears in a column, with a unique value in another column - For example;
If I wanted to count 'Bathroom' then it would return 2 and for Kitchen it would return 1.
I've been messing around with COUNTIFS but can't seem to get it to work.
Can anyone help?