reducedjuice
Board Regular
- Joined
- Oct 29, 2008
- Messages
- 99
I'm wokring on a SUMIFS formula (obviously in Excel 2007) that seems to be formatted correctly, but is returning resuts of "0" for all when there shoudl be other values, so I'm in troubleshooting mode. If it helps, the original thread explaining my scenario is here.
General question on SUMIFS:
I have mutiple CriteriaRanges of dates. These ranges are referencing different columns of dates, and when I look at the Function Arguments by clicking Fx, I see that the formula is reading some of the dates in their DD-MMM-YY format, while others are reading it in the text format (ie. 39279). The question then is, does it read these 2 dates the same even though they are in different formats? Or, do I need to ensure that all date ranges are in the same format?
Thanks!
General question on SUMIFS:
I have mutiple CriteriaRanges of dates. These ranges are referencing different columns of dates, and when I look at the Function Arguments by clicking Fx, I see that the formula is reading some of the dates in their DD-MMM-YY format, while others are reading it in the text format (ie. 39279). The question then is, does it read these 2 dates the same even though they are in different formats? Or, do I need to ensure that all date ranges are in the same format?
Thanks!