Sumifs with multiple criteria

Amanda Medina

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.

Stefan

Hi @Amanda Medina ,

SUMIFS works the other way round than SUMIF.

You put the range to be summed first:

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

And you wrote "LM Tech" but in your formula you write "GE Tech"...

Hope this helps

Stefan

Stefan

Hi @Amanda Medina ,

SUMIFS works the other way round than SUMIF.

You put the range to be summed first:

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

And you wrote "LM Tech" but in your formula you write "GE Tech"...

Hope this helps

Stefan

Amanda Medina

Stefan,

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

Stefan

Happy to help :-)

Stefan