How do I format a formula to recognize multiple comparison factors
 

I'm trying to build a Roll-Up page. I would like to pull data from other
worksheets within the workbook to get a summary of expenses to date. I need
to build a formula to recognize a catagorization code as well as refer to a
specific date range, so that It can pull only specified expenses to the
apporpriate field.