Forum Discussion
Need a separate sheet to return total income for each month
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.
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.
In B2:
=SUMIFS(Table22[Income], Table22[Date], ">="&A2, Table22[Date], "<"&EDATE(A2,1))
where Income and Date are the names of the relevant columns in Table22.
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.