Spreadsheet Function creation?
"jkuhne" wrote in message
...
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?
Assuming your headings Strength, Type and Direction are in row 1, so your
data will begin in A2:
=SUMPRODUCT((A2:A6="left")*(B2:B6="run")*(C2:C6="l eft"))
Alternatively, you could put
"left" in (say) A50,
"run" in B50,
"left" in C50
(without the quotes).
The formula would then be
=SUMPRODUCT((A2:A6=A50)*(B2:B6=B50)*(C2:C6=C50))
This version is better for making many copies of the formula with different
combinations of conditions.
|