Dear All, With reference to the attached sample file, I applied SUMIFS formula, but I am getting the wrong answer “#Value! May I know what is wrong with SUMIFS formula?