SUMIFS with Named Ranges

[KeithS.]

I'm trying to learn more about the SUMIFS and COUNTIFS functions and am practicing with some hypothetical data. I have data about the number of gallons of paint sold in 4 regions.

In my hypothetical situation, I need to find out the number of gallons sold in the Northeast region during the month of August.

I have named ranges for most categories: "Date," "Gallons_Sold," "PaintColors," and "Region."

I am able to get a correct response if I use
=SUMIFS(Gallons_Sold,Region,"NE",Date,"August 21")
–but it is only info. for a single date. I need to get a total for the entire month of August.

=SUMIFS(Gallons_Sold,Region,"NE",Date,"August") returns zero. How do I get SUMIFS to evaluate "Date" for all August dates?

Any help is greatly appreciated!

 

[circledchicken]

Yes - I've discovered the ExcelIsFun channel - thanks for the heads up!

So ... is the reason my formula can't find "August" or "August*" because the dates aren't "real" dates?

[I guess I could format my dates as "General" and use (...Date,"41128")]

No, my formula assumed you had entered the dates as text and not as real dates. It seems from your post #3 that they are actual date values, so as barry houdini said see Aladin's post #5.