SodaAddict
New Member
- Joined
- Jul 4, 2008
- Messages
- 4
Basically, I have a spreadsheet where there's a ton of data and I need to have a formula that searches through one column row by row, then goes to another column on the same row if the first one returns a certain value. Then, once in the second column, I want it to add a number to a count if that reurns a certain value.
I realize this may sound complicated, so I will put some sample data below.
1 2 3
A Low Yes Yes
B Middle No Yes
C High Yes Yes
D Low No No
E High Yes No
F Low No Yes
G Middle No No
Now, what I need to be able to do is have the formula search through column 1 until it sees "Low", then jump to column 3 on the same row and see if that says "Yes", and if so, count the number. Thus, in this example, I want the formula to return 2, because there are two places (Row A and Row F)where Column 1 contains "Low" and Column 3 contains "Yes". Then, I want to repeat this formula for other columns.
I tried doing it with Countif, but I could only make that work if it was one column. If you need any more info, feel free to ask.
I realize this may sound complicated, so I will put some sample data below.
1 2 3
A Low Yes Yes
B Middle No Yes
C High Yes Yes
D Low No No
E High Yes No
F Low No Yes
G Middle No No
Now, what I need to be able to do is have the formula search through column 1 until it sees "Low", then jump to column 3 on the same row and see if that says "Yes", and if so, count the number. Thus, in this example, I want the formula to return 2, because there are two places (Row A and Row F)where Column 1 contains "Low" and Column 3 contains "Yes". Then, I want to repeat this formula for other columns.
I tried doing it with Countif, but I could only make that work if it was one column. If you need any more info, feel free to ask.