C
Catrina
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.
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.