ThomasBrandt08
New Member
- Joined
- Oct 29, 2011
- Messages
- 3
I basically have a spreadsheet, where the first 4 columns contain unique values (such as different species of trees and soil types) (and only one values in each cell.)
The following columns should list how many times each type of value occur, for example - there is a column that should count the total number of trees listed in the first 4 columns, and there is a column that should count how many times soils are listed, and so on.
Let me further describe what I need with the use of the trees example:
Column 1: pine species
Column 2: redwood species
Column 3: green grass
Column 4: grey sand
Trees column: HERE WE WANT IT TO COUNT THE 2 TREES AND LIST THE NUMBER 2
The formula should therefore look at column ONE and count a 1 if a tree is listed OR a 0 if something else is listed.
Then it should look at column TWO and add a 1 if a tree is listed OR a 0 if something else is listed - and add this number to what it found from column ONE
Then it should look at column THREE and add a 1 if a tree is listed OR a 0 if something else is listed - and add this number to what it found from column TWO
Then it should look at column FOUR and add a 1 if a tree is listed OR a 0 if something else is listed - and add this number to what it found from column THREE
Finally, the formula should place the total value (from 0 to 4) in the "Trees" column.
Thank you in advance for any help.
Cheers,
Thomas
The following columns should list how many times each type of value occur, for example - there is a column that should count the total number of trees listed in the first 4 columns, and there is a column that should count how many times soils are listed, and so on.
Let me further describe what I need with the use of the trees example:
Column 1: pine species
Column 2: redwood species
Column 3: green grass
Column 4: grey sand
Trees column: HERE WE WANT IT TO COUNT THE 2 TREES AND LIST THE NUMBER 2
The formula should therefore look at column ONE and count a 1 if a tree is listed OR a 0 if something else is listed.
Then it should look at column TWO and add a 1 if a tree is listed OR a 0 if something else is listed - and add this number to what it found from column ONE
Then it should look at column THREE and add a 1 if a tree is listed OR a 0 if something else is listed - and add this number to what it found from column TWO
Then it should look at column FOUR and add a 1 if a tree is listed OR a 0 if something else is listed - and add this number to what it found from column THREE
Finally, the formula should place the total value (from 0 to 4) in the "Trees" column.
Thank you in advance for any help.
Cheers,
Thomas