Forum Discussion

Sarah675's avatar
Sarah675
Copper Contributor
Feb 13, 2023
Solved

Calculate data from two colums to give a total

Is it possible to calculate data from two colums to give a total number that match both criteria.

 

Eg:  Number of those that say "B" in colum D and also says "live" in colum L. 

Formulas and Functions
  • Martin_Weiss's avatar
    Martin_Weiss
    Bronze Contributor
    Feb 13, 2023

    Hi Sarah675 

     

    yes, this can be done using the COUNTIFS function:

     

    =COUNTIFS(D1:D8,"B",L1:L8,"live")

     

      • Sarah675's avatar
        Sarah675
        Copper Contributor
        Feb 14, 2023

        Can this also be used to calculate those that do not include a word? 

Resources