Forum Discussion
Calculating data from columns if they equals a text
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"
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.
I know I don't know anything (Socrates)