SUMIFS 3 criterias

Hi,

I'm trying to create a formula with 3 criteria but it doesn't work.

Here it is:

=SUMIFS({Hours (1)}, {Période de paie ING}, [Période de paie]@row, {Centre de coûts Projets 1}, [Numéro de projet]@row, {Colonne Employee name}, {Alberto})

When I remove one of the criteria (no matter which one), the formula works well! I don't get it...

Answers

  • Ramzi K
    Ramzi K ✭✭✭✭✭

    I think your issue is that  {Alberto} in your formula is not a criteria. You need to point to a cell or a value instead of a range (assuming that {Alberto} is pointing to a range in another sheet).

    Notice how [Période de paie]@row for criteria 1 and [Numéro de projet]@row for criteria 2 are values whereas {Alberto} is probably pointing to a range in another sheet.

    I hope that helps.

    Ramzi

    Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)

    Feel free to email me: ramzi@cedartreeconsulting.com

    💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.

  • Hi Ramzi,

    {Alberto} point a cell in another sheet (complete name)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!