Hello all and greetings!
I'm creating a transaction register that will allow me to pull the value of all transactions given a specific month. Sample of the formula I've attempted without success:
=IFERROR(SUMIF(Table4[Date],"Month(1)",Table4[Deposit, Credit (+)]),"Nope")
Mentally, the criteria are the formatted date, the criteria are the month in that formatted date and the returned value should be transactions that happened during that month.
Can anyone help?
To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Re: Help with a date formula, please!
Hey FDibbins, thanks for the reminder!
If anyone has tips or tricks for adding a countif function that also counts the number of "January" in the range "date" that'd be swell too.
Why did you convert the table to a range? Have you ever looked at a pivot table?
I made a table of your data.
After that I add a column to determine the month and Year; also the value.
After that a Pivot Table.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thanks for the assistance, this works!Originally Posted by oeldere
Initially, I hadn't, but it seems as though that may be the best option. Thanks for the input!
Glad I could help.
Thanks for marking the question solved.
You can add reputation by clicking on the star * add reputation.
@oeldere,
Why beg for reputation? Where can you find those things? The distribution was successful
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks