Forum Discussion
Solved
Need a separate sheet to return total income for each month
Hi, I'm struggling with what I thought would be a simple Sumifs function. Named sheet "income 2022" has the date in column A and the income in column G. All this data is in a table called "table2...
I wrote in a previous reply:
I'd use dates in column A on the Monthly Income sheet:
01-Jan-2022
01-Feb-2022
etc.
Format the dates as mmm or mmmm so that only the month name is displayed.
You didn't do that. See the attached version.
HI, see sample workbook. Sorry for delay.
https://www.dropbox.com/s/jscbrilf2ff4cho/Sample%20workbook.xlsx?dl=0
https://www.dropbox.com/s/jscbrilf2ff4cho/Sample%20workbook.xlsx?dl=0
I wrote in a previous reply:
I'd use dates in column A on the Monthly Income sheet:
01-Jan-2022
01-Feb-2022
etc.
Format the dates as mmm or mmmm so that only the month name is displayed.
You didn't do that. See the attached version.
- Thank you so much and for pointing out where i've gone wrong.
Much appreciated.