SUMIFS 3 criterias

Julie Barbeau

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...

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

Julie Barbeau

Hi Ramzi,

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