Forum Discussion

Virgil0312's avatar
Virgil0312
Copper Contributor
Mar 12, 2022

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"

excel
Formulas and Functions

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Mar 13, 2022

    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)