Hi All, need a sumifs formula agints marks and name output required pass or fail. sample file enclosed for reference. thanks jawahar