# Count / Sum Numbers In Column Where Specific Text Exists In Adjacent Cell

Jan 19, 2008One has numbers the other has "YES" or is blank. I want a formula to look at the second column and where there is a "Yes" then count the number in the same row in the first column.