MATCH function with a <>0 value

[ABC3132]

Hi all.

I have the following JasonB75 advises which have been very useful.

Now I´m trying to search into the cell, only certain features in order to compare the sales of the SAME PERIOD

So, you need to know what column values has to do the right comparation

2019​	2019​	2019​	2020​	2020​	2020​
January	February	March	January	February	March	Phasing
5​	0​	25​	7​	8​	0​	300.00%​

January+February 2020 vs January+February 2019
what funciotn should I use?

Many Thanks!

 

[ExcelGzh]

I suggest using SUMIFS

=SUMIFS(RowWithNumbers,RowWithMonths,"January",RowWithYears,2019) + SUMIFS(RowWithNumbers,RowWithMonths,"February",RowWithYears,2019) and so on.

 

[ABC3132]

Thanks ExcelGzh fro your time