Summing data by month
I have tried this for "April" and "January" however it keeps bringing back 0.
Can you recheck? Parenthesis ?
Thanks
"Bob Phillips" wrote:
=SUMPRODUCT(--MONTH(A2:A200)=4),B2:B200)
should do it for April
--
__________________________________
HTH
Bob
"Valerie" wrote in message
...
I have random dates in one column (formatted as: April 13, 2009) and
dollar
values in the column next to the dates. How can I sum, for example, all
April dollars or all June dollars? I have another tab that is summarizing
the data by month. So, the data is summarized in this tab with each month
alpha listed ("April", or "June"). Can I sum all "April" data that is
formatted as mm/dd/yyyy?
Thanks,
|