Michael Paxton
asked on
Sum by month
I am trying to sum by month based on the attached spreadsheet. I have tried searching for an answer to this, and when I use what I think is the correct array formula, I get a #Value error.
Thanks,
Michael expert-exchange-datesum-example.xlsx
Thanks,
Michael expert-exchange-datesum-example.xlsx
Which column? Can you clarify more please.
ASKER
Sorry, I am trying to sum Column F.
ASKER
I have been getting an error using this formula
=SUMPRODUCT((MONTH($A$2:$A $225)=MONT H(I1)*($B$ 2:$F$225)) )
=SUMPRODUCT((MONTH($A$2:$A
Based on your workbook you would need:
=SUMPRODUCT((MONTH($A$2:$A $225)=MONT H(H2))*($F $2:$F$225) )
=SUMPRODUCT((MONTH($A$2:$A
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Not sure if you have correct columns in that formula:
Column I is empty.
$B$2:$F$225 this is a wide range.
Could you show a sample of what you expect the formula to do? I am not sure I got you correctly.
Column I is empty.
$B$2:$F$225 this is a wide range.
Could you show a sample of what you expect the formula to do? I am not sure I got you correctly.
ASKER
Spot on formula!