Calculating data from columns if they equals a text

Occasional Visitor

Q? pertaining to calculating numbers in a column of 100 cells. I rarely work with logic functions and I want to calculate only the value if the cell states "county" and next cell states "yes"

1 Reply


I don't know from the description whether this is exactly what you are looking for, but here is a formula suggestion in this direction.




Add your own values to the formula and it should work.


Hope I was able to help you with this information.



I know I don't know anything (Socrates)