View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stephen[_2_] Stephen[_2_] is offline
external usenet poster
 
Posts: 364
Default 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.