I'm setting up a Sumifs formula that utilizes three criteria. One is from a column of dates. How do I phrase the formula to identify only a specific month and ignore the day? I thought it should be a simple process of string identification, but I'm stymied. Thanks for the help.
Steve
Last edited by SteveJF; 12-11-2010 at 11:44 PM.
Try something like these:
or...using a date cellD1: =SUMIFS(B1:B40,A1:A40,">=2/1/2010",A1:A40,"<3/1/2010")
Is that something you can work with?C1: 02/01/2010 D1: =SUMIFS(B1:B40,A1:A40,">="&(EOMONTH(C1,-1)+1),A1:A40,"<"&(EOMONTH(C1,0)+1))
Thanks Ron! It works fine... still surprised that it can't be something as basic as simple identification of a specific string, ie Jan, Feb etc.
Steve
Well, you asked for a SUMIFS solution...
If you're open to other approaches, here are a couple:
=SUMPRODUCT(--(TEXT(A1:A40,"mmm")="Feb"),B1:B40) =SUMPRODUCT((A1:A40<>"")*(MONTH(A1:A40)=2),B1:B40)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks