I am trying to find a way to get a sum only if it meets more than one requirement. Here's what is is: in column A, I have the employee's names. In column B, I have the date. In column C, I have a dollar amount. What I want to do is get a total for each person's transactions in a certain date range. For example, I want the total John sold in September. Can anyone of you excel Wiz's out there help me?