SUMIFS Function

what did you actually put? ">="&a1

Hello Russ, you need to concatenate the cell value, e.g. if you have your start of quarter date in F2 use

">="&F2

If you want you can make the cells update automatically with the start and end dates based on current date, e.g. using this formula for start date of the quarter

=EOMONTH(TODAY(),MOD(-MONTH(TODAY()),3)-6)+1

...and this for end date....

=EOMONTH(TODAY(),MOD(-MONTH(TODAY()),3)-3)

welcome to the forum, Russ. first off, it's not safe to use ">=7/1/13" and "<=9/30/13". that looks like MDY? your formula will fail when you send the file to someone like me because i'm using DMY in my date regional setting. use ">=1Jul2013" and "<=30Sep2013". that will work for all types of date regional settings.

not sure how you referred to a cell. assuming dates in Column A, values in column B, Criteria1 in D1 & Criteria 2 in E1, it should be something like:
=SUMIFS(B:B,A:A,">="&D1,A:A,"<="&E1)

if it cannot work, I suggest you upload an Excel file in the thread. To do that, Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
and to illustrate your example better, click on How To Get Quick & Good Answers