Hi, I need to use the sumif function to return some no., however some of the criteria cell has more than one value (range of values), so how can I key the criteria cell so that the sumif function returns the value? Please help. Many thanks !
E.g.
GL Amount
1000 =sumif(xxx
1800-2000
2100-2110
Bookmarks