gnaga
Well-known Member
- Joined
- Jul 9, 2002
- Messages
- 748
- Office Version
- 365
- 2016
- 2013
- Platform
- Windows
Hi,
My data is spread into three columns and 100 rows. (A1:C100). I would like to count the rows based on the values in each column. Example as given below.
A B C
1 1 1 1
2 -1 -1 -1
3 1 -1 0
4 -1 0 1
5 1 1 1
.
.
.
100
For criteria = 1 count of rows = 2 (Row 1 & 5)
For criteria = -1 count of rows = 1 (Row 2)
How can I use the countif or sumif to get this?
My data is spread into three columns and 100 rows. (A1:C100). I would like to count the rows based on the values in each column. Example as given below.
A B C
1 1 1 1
2 -1 -1 -1
3 1 -1 0
4 -1 0 1
5 1 1 1
.
.
.
100
For criteria = 1 count of rows = 2 (Row 1 & 5)
For criteria = -1 count of rows = 1 (Row 2)
How can I use the countif or sumif to get this?