08-23-2019 07:01 AM - edited 08-26-2019 06:01 AM
08-26-2019 09:34 AM - edited 08-26-2019 09:36 AM
Whilst it is possible to use ranges other than a simple column array, it is rare that such a strategy is useful. The problem with the x_IFS() functions are that the criterion parameters must be range references of the same shape as the data you are processing. Thus the country row and the revenue category columns would each need to be broadcast to fill a 2D table.
Something that would be possible in your example would be to down-select the 2D data array to a single row by using
= CHOOSE( index, row1, row2 … )
= INDEX( dataTable, index, 0 )
before using SUMIFS with the country criterion only.
10-18-2019 08:53 AM - edited 10-21-2019 09:18 AM
Hi @Sergei Baklan ,
I attempted to replicate the formula you had created for me into another file, but apparently I am doing something wrong. Would appreciate your help again if you could please review the attached and advise on what I need to adjust. The cells are on the first tab highlighted in green.
by Lenabrandecker on June 05, 2020
by Khanh_Mai on June 04, 2020
by Ingeborg Hawighorst on May 13, 2020
by cuong on April 22, 2020
by cuong on April 15, 2020
Posted in Microsoft Ignite The Tour 2019 on February 14, 2020