Using SUMIFS with date range
 

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.

Using SUMIFS with date range
 

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.

Using SUMIFS with date range
 

Hi
I assume you enter the customer name in A1, start day in B1 and finish day
in B2. then your information starts with customers name in cell A5, dates in
B5 and you want to summarize column C

=sumproduct(--($A$5:$A$1000=$A$1),--($B$5:$B$1000=$B$1),--($B$5:$B$1000<=$B$2),$C$5:$C$1000)

"Catrina" wrote:

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.

Using SUMIFS with date range
 

Perfect. Thank you!

"Fred Smith" wrote:

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.

.

Using SUMIFS with date range
 

You're welcome. Thanks for the feedback.

Fred

"Catrina" wrote in message
...
Perfect. Thank you!

"Fred Smith" wrote:

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.

.