Sumifs with multiple criteria

Hello again! Yes, I am working on a Saturday...these formulas are killing me!

I am trying to sum the number of techs that are both "Transactional" and "LM Tech", referencing "Availability" sheet. This is the formula I am using:

=SUMIFS({Availability Range 1}, "transactional", {Availability Range 19}, "GE Tech", {Availability Range 2})

The formula should use the criteria in Range 1 and Range 19 to determine if the cell should be summed. The value in Range 2, should be summed.

Best Answer


  • Stefan,

    Thank you for your response! I your suggestion worked beautifully! Thank you so much!

  • Stefan
    Stefan ✭✭✭✭✭✭

    Happy to help :-)


    Smartsheet Consulting, Solution Building, Training and Support.

    Projects for Processes and for People.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!