Get instant live expert help on I need help with excel sum by month and year

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Need to sum the month dates into year date --- ex: year 2018 is the sum of all months in 2018. Formula in I6 does not capture entire dates to the right by month into 2021. Same with all cells in green formulas fro cells I6 to N183. See attached.
Solved by G. H. in 28 mins
I need help with a formula. I need the formula to read a date and return the data for the line and column. i also need it to return the sum of the column by week, by month, by year. I have the daily data worked out by changing the date in cell A2. I can not figure out the week, month , year sums.
Solved by K. D. in 21 mins
I have a problem regarding to Get last entry by month and year
Solved by X. L. in 29 mins
I am having an issue with an excel formula not returning the expected results. =IF($F2<>"",IF(YEAR(Y$1)&MONTH(Y$1)<=YEAR($F2)&MONTH($F2),$T2,IF(YEAR(Y$1)&MONTH(Y$1)>YEAR($F2)&MONTH($F2),0)),$T2)
Solved by C. D. in 21 mins
Calendar setup on Excel sheet for selected month and year
Solved by G. H. in 12 mins