Google Sheets- Formula SUMIFS with cell reference doesn't give value

enter image description here


When i write this formula IT WORKS:


But when i write it differently, there is no result:


The result is 0.

Even when i try to reference it with row formula, As image shows, it doesn’t give result:


I expected to get the same result as the first code


Any ideas why it doesn’t work?


>Solution :

You must use this =SUMIFS($D$4:$D$9,$A$4:$A$9,B1,$B$4:$B$9,INDIRECT("B"&"2")) to make it work.

Leave a Reply