View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jkuhne jkuhne is offline
external usenet poster
 
Posts: 1
Default 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?