Dears, Following formula is giving "Value" error. Can you please fix my issue. =SUMPRODUCT(--(X$3:BL$3=S1),A$4:A$49,AH$4:AH$49) I have attached a sample file for your review. Thanks in Advance!