I am having trouble summing when using multiple criteria. i.e. I want to
search column I for a certain product, then search column J for its place in
production (opened, approved, sent, returned) and then sum the corresponding
dollar amount from column B based on it's spot in production. I have done
similar things based on date/time stamps using isblank or isnumber, but
cannot seem to do it using a second text designation. Any help would be
appreciated.