Michael Paxton
asked on
Sumproduct for Month range with additional criteria problem
I am using the following formula to sum the data by month and where fund type equals "Unrestricted" I am getting 0 as a value. Any suggestions?
=SUMPRODUCT(--(MONTH(!$A$2 :$A$20)=MO NTH(Report StartDate) ),--(YEAR( $A$2:$A$20 )=YEAR(Rep ortStartDa te)),--$E$ 2:$E$20,D2 :$D$20="Un restricted ")
The formula works until I add in the "Unrestricted" contraint.
Sumproduct-sheet.xlsx
=SUMPRODUCT(--(MONTH(!$A$2
The formula works until I add in the "Unrestricted" contraint.
Sumproduct-sheet.xlsx
ASKER
Thomas,
This still returns 0 as a solution.
Michael
This still returns 0 as a solution.
Michael
Hi.
I think you want SUMIFS().
Kevin
I think you want SUMIFS().
Kevin
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
=SUMPRODUCT((MONTH($A$2:$A
Thomas