Something like this:

=sumifs(A:A,B:B,B3,C:C,"="&B1,D:D,"<="&B2)

Regards,
Fred

"Catrina" wrote in message
...
I am trying to sum a column of cells if several criteria are met...1. equal
to specific customer name, 2. is greater than or equal to a beginning date
entered into a specific cell and 3. is less than or equal to an end date
entered into another specific cell. I can get the formula to work if I
use
the beginning and end dates in the SUMIFS formula, but I don't want to
change
the formula each time I run the spread. So I want to be able to data
enter
the begin and end dates in certain cells (line in B1 and B2) so I only
change
those dates to recalculate the totals.