Spreadsheet Function creation?
I have 3 columns of information. At the bottom of each column I have a
countif formula counting the amount of times a condition occurs... How do I
create a formula to count how many times a specific condition occurs across
the 3 columns...
For example.
Column 1 Column 2 Column 3
Strength Type Direction
Right run right
right pass right
left pass right
left run left
left run left.
I want to calculate how many times
strength is: left
& Type is: run
& Direction is: left
How do I do this?
|