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,
Thank you for prompt reply. Unfortunately, currently returning a 0 value for every month.
=SUMIFS(Table22[Income - Vatable], Table22[Date], ">="&A2, Table22[Date], "<"&EDATE(A2,1))
Table date is 01-Jan-22
Date in A2 is MMM
Anything else I'm missing?
Thank you for prompt reply. Unfortunately, currently returning a 0 value for every month.
=SUMIFS(Table22[Income - Vatable], Table22[Date], ">="&A2, Table22[Date], "<"&EDATE(A2,1))
Table date is 01-Jan-22
Date in A2 is MMM
Anything else I'm missing?
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- HI, see sample workbook. Sorry for delay.
https://www.dropbox.com/s/jscbrilf2ff4cho/Sample%20workbook.xlsx?dl=0I 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.