samedi 9 mai 2015

Excel formula: Sum if two columns match

I need a formula that only sums numbers in a cell from a column if it matches two cells in the same row.

In J3 i'm trying to get the sum of all the returns that are from January 2009. In J4 'm trying to get the sum of all the returns that are from february 2009. And so on.

The datasheet

I tried different sumifs but it didn't return the value.

Aucun commentaire:

Enregistrer un commentaire