Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I cannot seem to find an answer, so I am posting he
A B C D E F G H 1 1 5 3 4 2 2 1 4 4 3 5 3 2 3 4 4 3 4 2 3 3 3 5 What I am looking to do is create a formula that can look in columns A through D for the numer 1. Then in those rows that have the number 1, to count the numbers in that same row where there is a 5. So in the example above, there are two rows with the number 1 - and if you count the cells in those two rows that have the number 5, it would equal 2. I was trying to create this as one formula. Any help is appreciated. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
better way to write a count if statement? | Excel Worksheet Functions | |||
Count If Statement Using Dates | Excel Discussion (Misc queries) | |||
Help with Count IF Statement | Excel Discussion (Misc queries) | |||
count if statement | Excel Discussion (Misc queries) | |||
How do I write a conditional statement in Excel to count if two c. | Excel Worksheet Functions |