SumIF for multiple criteria to include date falls in particular month

cfhasan1
cfhasan1 used Ask the Experts™
on
I trying to create a formula that reference a range and fall in a specific month and gives the sum.  For example, if Range code = EDD and falls in January return sum of all occurrences.

The  range containing the reason codes and dates are on a different tab.  The formula needs to reference the reason code in the table against the corresresponding reason code in the tab contain the log reasons and date
Table

Reason     Jan    Feb     Mar
EDD
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Tom FarrarConsultant

Commented:
Providing the spreadsheet would be helpful.  The sumifs function might give you what you need.

http://www.excelfunctions.net/Excel-Sumifs-Function.html
Tom FarrarConsultant

Commented:
A pivot table is also a great tool for doing what you are asking.  Assuming the data looks like what I have provided as an example.  See spreadsheet.
EE.xlsx
Consultant
Commented:
Or if your date is mm/dd/yr, then you can use the grouping function in the pivot table like the attached example.  An advantage of the pivot table is if your source data is defined as a table (Ctrl/T keystroke) then it will expand or detract as the number of rows change if, for instance, the data was changed every month.
EE.xlsx

Author

Commented:
Great!  This provides me with exactly what I was looking.
Tom FarrarConsultant

Commented:
Glad to help..

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial