Hi All, need help. I’m trying to sumif by two columns (Item and Name), I have been able to transponse( distinct “Name” as the column and item as the row, but when I write cell to pass the formula, it returns as below, I have also attached the ideal output. Help. Please share a xaml file to see what I’m doing wrong. Also attached is the excel. Also how do I ensure that if the column or row increases/decreases the formula fills for all.
DataTEST.xlsx (18.3 KB)