| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Last cell in Range when range is date format | Excel Discussion (Misc queries) | |||
| Sumifs - incorrect when using date in critera | Excel Worksheet Functions | |||
| SUMIFS based on date | Excel Worksheet Functions | |||
| Sumifs with error value in the sum range | Excel Discussion (Misc queries) | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Threaded Mode
