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

@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)