Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Syntax for Info or Cell function for xl. file creation date | Excel Worksheet Functions | |||
Dialogbox Creation | Excel Discussion (Misc queries) | |||
Formula creation...if possible | Excel Worksheet Functions | |||
Columns creation | Excel Worksheet Functions | |||
Spreadsheet Creation | Excel Discussion (Misc queries) |