Consider column N to contain random dates, MM/DD,YYYY from Jan through Dec - in a nonsequential order. The adjacent column O contains dollar values. How can i write a SUMIF(or other formula) that will total dollars for a given month. I can't figure a way to get SUMIF to accept a range of values (i.e., between) in lieu of a specific value. I would have the formula in multiple cells to total sales for Jan, Feb, etc.
Thanks,
GDawg
Thanks,
GDawg