Dear All,

Actually SUMIF function will be like SUMIF(Range, Criteria, SUM Range)

SO here I want range (in the sumif function) to be taken automatically rather than me selecting the particular range based on header

Ex: I'm using formula =SUMIF(Production!$A$37:$AG$45,Export!A2,Production!$BL$38:$BL$45) where as it is returning zero even there is a value for that particular item