SUMIF based on multiple date criteria

**titantough** · 06-13-2011, 02:15 PM

I have a somewhat suitable formula to enter values based on multiple criteria into a worksheet from other worksheets in my workbook.

Please Login or Register  to view this content.

I would like to know if there is anyway i can use a cell reference to the dates i specified in row 1 of cashflow worksheet, rather than manually entering in the dates in the formula. This will help when i have to change the dates in row 1. I tried to enter C1 and D1 as "datevalue" to see if that would help...

Any suggestions are appreciated.

**NBVC** · 06-13-2011, 02:19 PM

Replace the whole Data function with just the cell reference.

e.g.

SUMIF(Labour!CASHFLOW_LABOUR_DATE,"<="&D$1,......

**titantough** · 06-13-2011, 02:44 PM

Well, wasn't that easy? Are you able to tell me why i need the "&" symbol in my formula?

Thanks so much

**NBVC** · 06-13-2011, 02:54 PM

I am not sure how to explain it, but with Sumif and Countif and other 2007 counterparts... Averageif, Countifs, Sumifs, you have to enclose conditions within quotes except for when doing a direct reference like such as you are doing. You also had it in your original formula where the operator "<=" was enclosed in quotes, but the DATE() function wasn't it, since it itself was being evaluated.. and if it were in the quotes, it would not be evaluated.... Excel is funny that way....