The criteria is the GL no. e.g. 1000, 1800, 2000,etc. There is a correspondence amount for each GL, in another tab, however I'm unable to use the sumif function in this tab because the GL no. is a range, e.g. from 1800 to 2000. Please see the attachment.
Bookmarks