Calculating data from columns if they equals a text

[Virgil0312]

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"

[#2]

@Virgil0312 

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.

=IF(AND(A1="county",B1="yes"),A5+A6,"empty")

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

Hope I was able to help you with this information.

NikolinoDE

I know I don't know anything (Socrates)