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
Bookmarks